what is Difference between Having and Where clause?

Answer Posted / nrapendra

where clause filter the data before gruop by clause and
having clause clause filter the data after group by clause

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is join same as left join?

753


Which is better join or subquery?

793


what is index? : Sql dba

747


What is range partitioning?

692


What are actual parameters and formal parameters?

778






What is a constraint? Tell me about its various levels.

839


What are the methods of filing?

676


Can we group by two columns in sql?

729


What is compiled query?

744


What is use of package in pl sql?

713


what are dynamic queries in t-sql? : Transact sql

743


Can procedure in package be overloaded?

837


Does sql require a server?

709


What are all the different normalization?

744


What can I use instead of union in sql?

708