Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30458 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 dbrm? What it contains?
Explain packages.
What is the use of with ur in db2?
What is temporal table in db2?
What is page size in db2?
What do you mean by commit and rollback?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Explain package in db2 and its advantages?
How do I delete a column in db2?
How can you classify the locks in db2?
What is a dbrm in db2?
Why db2 is called db2?
Which is faster delete or truncate?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Mention the location where the output received from explain statement is stored.
