Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30456 Views
- IBM, iFlex, I also Faced
- E-Mail Answers
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
Differentiate between cs and rr isolation levels? Where do you specify them?
What is syscat in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is buffer pool in the db2 database?
What is the difference between nvl and coalesce?
What is the maximum No of rows per page?
How to get the ddl of a table in db2?
What is bufferpool in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is buffer pool and list some of them?
What is ibm db2 client?
Give a brief description of db2 isolation levels?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is runstats and reorg in db2?
What is db2 connect?
