what is the difference between where clause and having clause
Answer Posted / selvam a
HAVING clause can only compare a built in function but WHERE
clause can compare column name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is db2 catalog database?
Mention the various locks that are available in db2.
What is copy pending status in db2?
What is a page in db2?
What is phantom read in db2?
How can you quickly find out the # of rows updated after an update statement?
Which isolation level provides highest data integrity?
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?
Is schema the same as database?
What os does db2 run on?
What are host variables in db2?
How do I optimize a query in db2?
What is the use of dclgen in db2?
What is difference between alias and synonym in db2?
What is page size in db2?