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

Why use triggers in sql?

489


What is record variable?

542


What is fmtonly in sql?

522


What is sqlerrd?

518


What are the two different parts of the pl/sql packages?

553






How do you update sql?

515


How do you copy a table in sql?

553


What is a database trigger?

600


Is sql a case sensitive language?

507


What is the use of procedures?

534


What are all types of user defined functions?

520


What is a natural join sql?

507


How would you convert date into julian date format?

587


How to assign sql query results to pl sql variables?

504


Can we group by two columns in sql?

499