What is the difference between Where and Having Clause

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


Please Help Members By Posting Answers For Below Questions

What is cursor with hold option in db2?

614


i want to maintain uniqueness on pdf without make lf??????????

1637


What types of tables are there in the db2 database?

557


What action db2 takes when a program aborts in the middle of a transaction?

659


What does reorg do in db2?

578






What is db2 command?

586


What is the difference between bind and rebind in db2?

858


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

706


Where do you specify them?

681


What does db2 mean?

589


How do you select a row using indexes in db2?

647


What is the usage of open cursor command?

601


How do I create a view in db2?

606


How to create backup table in db2?

645


what is db2 restart?

1695