Having clause works on recordset while Where works on individual record

What is the difference between HAVING clause and the WHERE
clause?

Question Posted / ishika

Answer Posted / ishika

Having clause works on recordset while Where works on
individual record

Is This Answer Correct ?

15 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How do I find the port number for sql server?

955

What is the template in sql?

963

How will you make an attribute not process? : sql server analysis services, ssas

1065

What is statement level trigger?

966

How are the unique and primary key constraints different?

1046

Name and describe few console utilities for ssrs?

284

Explain in brief about Microsoft SQL server?

1066

What is an sql server agent?

1042

What is the difference between varchar and nvarchar?

929

How to verify a login name with sqlcmd tool?

1196

What is query cost in sql server?

979

Explain the architecture of ms sql reporting service?

906

What are “lock” hints?

1045

Do you know what is difference between index seek vs. Index scan?

936

Explain the dbcc pintable command when would you use it?

894