what is Difference between Having and Where clause?

Answers were Sorted based on User's Feedback



what is Difference between Having and Where clause?..

Answer / 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

what is Difference between Having and Where clause?..

Answer / ganesh

where clause check a condition & having clause is use in
group by clause

Is This Answer Correct ?    12 Yes 2 No

what is Difference between Having and Where clause?..

Answer / 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

what is Difference between Having and Where clause?..

Answer / 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

what is Difference between Having and Where clause?..

Answer / tanmoy

We can use arithmetic operator in having clause but it is
not possible for where clause..

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More SQL PLSQL Interview Questions

What is the difference between the implicit and explicit cursors?

0 Answers  


Can procedure in a package be overloaded?

1 Answers   HCL,


What are different clauses used in sql?

0 Answers  


What is a sql schema used for?

0 Answers  


Mention what does plv msg allows you to do?

0 Answers  






what are the authentication modes in sql server? : Sql dba

0 Answers  


Explain isolation levels. : Transact sql

0 Answers  


What is sql integrity?

0 Answers  


Can we use having without group by in sql?

0 Answers  


what are the types of subquery? : Sql dba

0 Answers  


what is the sql query to display current date? : Sql dba

1 Answers  


How to get each name only once from an employee table?

0 Answers  


Categories