What is the difference between Where and Having Clause
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
Define buffer pool.
What is reorg?
Is the primary key a clustered index?
Why do we bind in db2?
What is the maximum number of columns in a db2 table?
What is db2 optimizer?
What does reorg do in db2?
What is dbrm?
Explain db2.
Are view updateable?
What is the physical storage length of the data types date, time, and timestamp?
What is runstats and reorg in db2?
Mention the definition of cobol in varchar field.
What is concurrency?
Describe major components of db2?