Having clause is applied only to the group by function where as where cla

what is difference between having and where clause ?

Question Posted / raju

Answer Posted / raju

Having clause is applied only to the group by function
where as where clause is applued to each and every row in a
table

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1086

Explain the properties of a relational table?

976

How do you open a cluster administrator?

1001

What authentication modes does sql server support?

1018

How to list all user names in a database?

1003

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

933

Write a query for primary key constraint with identity key word?

972

What is xdr?

929

Explain about extended stored procedure?

862

What is updatable resultset?

935

What command must you use to include the not null constraint after a table has already been created?

1050

How to search for a string in all stored procedure in sql server?

949

Give an example of why you would want to denormalize a database

924

What is a file group?

1018

What is replace and stuff function in sql server?

996