what is Difference between Having and Where clause?
Answers were Sorted based on User's Feedback
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 |
Answer / ganesh
where clause check a condition & having clause is use in
group by clause
Is This Answer Correct ? | 12 Yes | 2 No |
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 |
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 |
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 |
What is the difference between the implicit and explicit cursors?
Can procedure in a package be overloaded?
What are different clauses used in sql?
What is a sql schema used for?
Mention what does plv msg allows you to do?
what are the authentication modes in sql server? : Sql dba
Explain isolation levels. : Transact sql
What is sql integrity?
Can we use having without group by in sql?
what are the types of subquery? : Sql dba
what is the sql query to display current date? : Sql dba
How to get each name only once from an employee table?