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 sqlca?

606


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

694


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

652


What do you mean by rollback?

562


What is the meaning concurrency in the db2 database?

626






Define buffer pool.

616


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

1624


Can one database have multiple instances?

575


How to test SQL -911 error while developing COB-DB2 program

6696


What are the prerogatives?

609


Which isolation level provides highest data integrity?

586


How would you find out the total number of rows in a db2 table?

570


What is a cursor in programming?

584


What is db2 plan table?

608


What is the use of reorg in db2?

593