What is the difference between Where and Having Clause
- 7 Answers
- 27604 Views
- IBM, iFlex, I also Faced
- E-Mail Answers
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
What is access path in db2?
How can you quickly find out the # of rows updated after an update statement?
How to find the maximum value in a column in the db2 database?
How do you eliminate duplicate values in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is a db2 package?
Give a brief description of db2 isolation levels?
What is buffer pool in the db2 database?
Is the primary key a clustered index?
What's The Error Code For Unique Index Voilation?
Is db2 a programming language?
Where do you specify them?
What is the meaning concurrency in the db2 database?
What is the role of the data page in the db2 database?
Define predicate?
