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
When do you specify the isolation level?
How does a cursor work?
Explain the contention situations caused by locks?
what are bind concepts in db2 cobol?
Explain various types of locks in db2?
What is ibm db2 connect?
What r the comman abends in db2, jcl and cobol???????
What is nvl in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do I delete a table in database?
Mention the definition of cobol in varchar field.
What is a dbrm in db2?
What is a db2 collection?
Can there be more than one cursor open for any program?
How to find the number of rows in a db2 table?