What is the difference between Where and Having Clause
- 7 Answers
- 28633 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
can all users have the privilage to use the sql statement select * (dml)?
How to compare data between two tables in db2?
How do I change the column size in db2?
Why do we need reorg in db2?
Is db2 a mainframe?
What is db2 plan table?
What is declare cursor?
What is difference between rollback and commit?
What is the physical storage length of timestamp data type?
Explain what are the various isolation levels possible?
What does a deadlock mean in DB2?
How to create db2 table in mainframe?
How do you pull up a query which was previously saved in qmf?
Define db2.
What are packages in db2?
