What is the difference between Where and Having Clause
- 7 Answers
- 27531 Views
- IBM, iFlex, I also Faced
- E-Mail Answers
Answer Posted / s
WHERE filters the rows based on the predicate.
HAVING filters a group of rows based on the GROUP BY colums.
| Is This Answer Correct ? | 48 Yes | 10 No |
Post New Answer View All Answers
What is catalog database in db2?
What are the contents of a dclmgen?
What is the use of commit in db2?
What is db2 instance?
How do I start db2 in windows?
What is the use of predicate?
What is load utility in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is dbrm? What it contains? When it will be created?
What is difference between alias and synonym in db2?
What is buffer pool in the db2 database?
How and when does the db2 enforces the unique key?
How to run db2 command in windows?
What is copy pending status in db2?
What is the role of union all and union
