Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30500 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
Which command is used to remove all rows from a table?
what is the role of the cursor in db2?
What is buffer pool in the db2 database?
Explain db2.
What is db2 stogroup?
Is ibm db2 free?
How to execute stored procedures?
What is consistency token in db2?
Name the various locking levels available?
What is data manager?
What is dbrm? When it will be created?
What is ibm db2 client?
What is bind and rebind in db2?
What are the bind parameters ibm db2?
Highlight all the advantages that are attached to a package.
