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

What is equi join in sql?

604


What is form and report?

510


How many tables can you join in sql?

522


What is meant by truncate in sql?

520


Why indexing is needed?

509






What is the purpose of my sql?

500


which tcp/ip port does sql server run on? : Sql dba

507


What are different types of keys?

517


How to write a query to show the details of a student from students table whose

535


How do you break a loop in pl sql?

517


What are types of joins?

529


What is a unique key?

580


What is record in pl sql?

587


What are sql data types?

538


What is denormalization in a database?

585