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


Please Help Members By Posting Answers For Below Questions

Define buffer pool.

604


What is reorg?

591


Is the primary key a clustered index?

581


Why do we bind in db2?

595


What is the maximum number of columns in a db2 table?

693






What is db2 optimizer?

748


What does reorg do in db2?

550


What is dbrm?

620


Explain db2.

586


Are view updateable?

606


What is the physical storage length of the data types date, time, and timestamp?

580


What is runstats and reorg in db2?

763


Mention the definition of cobol in varchar field.

663


What is concurrency?

682


Describe major components of db2?

608