Having clause ia used only with group by, and where used with any input typ

what is difference between having and where clause ?

Question Posted / anil sharma

Answer Posted / anil sharma

Having clause ia used only with group by, and where used with any input type

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to change a login name in ms sql server?

1024

Can we do dml on views?

914

When multiple after triggers are attached to sql table, how to control the order of execution?

977

Can we add a cpu to sql server?

958

Why use “pivot” in sql server?

1042

How would you choose between a clustered and a non-clustered index?

917

What are indexes in ms sql server?

997

What is cte (common table expression)?

977

Explain indexing and what are the advantages of it?

962

What is the difference between commit and rollback?

876

Differentiate between truncate vs delete in mssql?

995

What is optimization and its types?

912

What is the use of @@spid?

957

Define normalisation?

1060

How can sql server instances be hidden?

894