what is Difference between Having and Where clause?

Answer Posted / chandrakala

Having clause is used for filtering grouped data and where
clause is used for filtering rows.

Is This Answer Correct ?    33 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we insert data into materialized view?

710


How delete all data from all tables in sql?

687


What does stand for in sql?

716


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

734


What is inner join in sql?

773






What is a join query?

722


What is pls integer?

779


How to use distinct and count in sql query? Explain

769


What is normalisation in sql?

779


List the ways to get the count of records in a table?

655


Is sql pronounced sequel or sql?

954


What is the current version of postgresql?

734


Explain the difference between sql and mysql.

753


Is left join and outer join same?

765


How do I use google cloud in sql?

732