What is the difference between having and where clause?

Answer Posted / kundan ravi

having clause alwaye use with aggregate functions and where
clause use for conditions but not with aggregate functions.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Replication?

809


What is acid mean in sql server?

739


Do you know what is lock escalation?

769


What is sql server database?

673


Explain the usage of floor function in sql server.

678






Define union, union all, minus, intersect?

741


How do I connect to sql server database?

684


What triggers long term care?

716


How to transfer a table from one schema to another?

742


Can we join two tables without primary key?

800


What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

635


What are the advantages of mirroring?

736


Explain about Joins?

764


How to reaname table name without using sp_Rename in sql server..?

727


What is coalesce in sql server?

729