What is the difference between Where and Having Clause
- 7 Answers
- 28592 Views
- IBM, iFlex, I also Faced
- E-Mail Answers
Answer Posted / narendra
Both are used to filter the rows but
where is used to filter the rows on single row functions and
having is used to filter the rows on group functions or aggregate functions.
one more thing i would like to mention is
having can be used without group by
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How do I delete a column in db2?
What is scrollable cursor in db2?
Mention the various locks that are available in db2.
What is the latest version of ibm db2?
What is the default page size of buffer pools?
What is query_cache_limit?
How to create backup table in db2?
What are db2 objects?
Which command is used to remove all rows from a table?
Is the primary key a clustered index?
How can you quickly find out the # of rows updated after an update statement?
What is db2? Explain.
How to rename a table in DB2 ?
What is db2 connect?
