we can use having clause without group bu clause .but it will act as wher

Can Having clause be used without Group by clause?

Question Posted / debasish

Answer Posted / debasish

we can use having clause without group bu clause .but it
will act as where clause

Is This Answer Correct ?

68 Yes

33 No

Please Help Members By Posting Answers For Below Questions

When I delete any data from a table, does the sql server reduce the size of that table?

956

Explain activity monitors

1001

Explain what is “asynchronous” communication in sql server service broker?

866

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1127

What are distributed partitioned views?

1005

What is command parameter in ssrs?

153

How you would rewrite the sql query to return the customerid sorted numerically?

935

What are the built in functions in sql server?

914

What is an indexed view?

915

What is a with(nolock)?

921

How to convert a numeric expression from one data type to another?

931

what is the sql equivaent of the dataset relation object ?

1959

How to connect of datebase with sql express.?

1049

What is the advantage of sql server?

985

How to download and install microsoft .net framework version 2.0?

1101