What is the difference between Where and Having Clause

Answer Posted / kums

Aso we can say that, WHERE filters the rows based on the
predicate. HAVING fill workd along with aggragate function.

Is This Answer Correct ?    21 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we bind in db2?

631


What is declare cursor?

613


What is the difference between oracle and db2?

587


What is precompiler in db2?

587


Highlight all the advantages that are attached to a package.

629






What is package in db2 mainframe?

559


What are the different types of base tables?

587


Can there be more than one cursor open for any program?

662


What is cobol db2?

570


What is collection in db2 bind?

577


What is iseries database?

597


Explain dclgen.

724


How can we retrieve the total number of records in RPG & CLLE?

197


Is db2 relational database?

574


What is a Foreign Key?

658