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

Answer Posted / chandra kanth

WHERE is for conditional retrieving and having is using
group of records

Is This Answer Correct ?    13 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the recovery model? List the types of recovery model available in sql server?

491


How to create an index on an existing table in ms sql server?

505


What are out-of-range errors with date and time literals?

562


What are sql dirty pages?

572


What is function of CUBE ?

618






What is difference between after and before?

515


What is an sql server agent?

555


wat wil hapn if we give the both read and deny read permission to user?

1660


What is the osql utility?

551


What are the properties of primary key?

525


how to control the amount of free space in your index pages? : Sql server database administration

604


what is a transaction and what are acid properties? : Sql server database administration

533


What are the differences between union, intersect, and minus operators?

584


What is bulkcopy in sql?

570


Difference between group by clause and having clause in SQL?

574