What is the difference between Where and Having Clause

Answer Posted / badal

both define condition
where for individiual records

group by for group of records

Is This Answer Correct ?    7 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the role of the data page in the db2 database?

587


What is the difference between cursor and select statement?

615


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

624


What is a db2 cursor?

626


What are packages in db2?

597






What is netezza database?

573


Explain about mirror activator disk mirroring?

560


What is null indicator in db2?

604


What do you mean by commit and rollback?

594


What is db2 instance?

592


is it compulsory commitment control in journal?

2013


What is a dbrm in db2?

576


What os does db2 run on?

572


What r the comman abends in db2, jcl and cobol???????

1820


When do you specify the isolation level?

608