what is Difference between Having and Where clause?

Answer Posted / joe

When we used group by that time only we can use having. But without group by we can use having.
Only grouped column have used in having condition

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why stored procedures are faster than query?

761


Show how functions and procedures are called in a pl/sql block.

766


How do you concatenate in sql?

723


What is clustered index in sql?

785


how to write date and time literals? : Sql dba

698






What are the datatypes available in pl/sql ?

793


what is try_catch block in procedure

1393


What is the basic form of sql query?

679


Is sqlexception checked or unchecked?

723


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

819


What are the advantages of normalization?

788


What is use of term?

794


What are the two types of exceptions.

824


What is the file extension for sql database?

671


Does oracle use sql?

685