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
Define declaration generator (dclgen).
What is dclgen in db2?
What is check constraint in db2?
Name the lockable units in DB2?
Highlight all the advantages that are attached to a package.
What is isolation level in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is a page in db2?
What is the maximum No of rows per page?
How to access db2 tables in mainframe?
How to execute stored procedures?
Explain the function of data manager.
Is ibm db2 open source?
When the like statement is used?
If I have a view which is a join of two or more tables, can this view be updateable?