What is the difference between Where and Having Clause
Answer Posted / njadav
Where Clause:
1)WHERE clause can be used without GROUP BY clause.
2)WHERE clause select rows before grouping.
3)WHERE clause can not contain aggregate functions.
4)WHERE clause can operate individual row.
5)It is more fast.
Having Clause:
1)HAVING clause can not be used without GROUP BY clause.
2)HAVING clause select rows after grouping.
3)HAVING clause can contain aggregate functions.
4)HAVING clause can operate group of row.
5)It is much slow.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Mention the downsides of page level lock.
How do I delete a column in db2?
What is the use of value function?
What is schema in db2?
What is difference between isnull and coalesce?
What is isolation level in db2?
What parameters are used to control the free space in DB2?
What is check constraint. Explain with example.
Give a brief description of db2 isolation levels?
What is the use of dclgen in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How can deadlocks be resolved?
What kind of database is db2?
What is db2? Explain.
What is database reorganization?