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
Explain packages.
What is db2 plan table?
When reorg is used?
What is db2 purescale?
How to find schema of a table in db2?
List down the types of triggers in the db2 database?
What is database manager in db2?
What is bind and rebind 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?
How would you find out the total number of rows in a db2 table?
When do you specify the isolation level?
What is the difference between db2 and oracle?
How do I add a column to a table in db2?
What is the reason behind not using select * in embedded sql programs?
What is the difference between dbm cfg and db cfg file in db2 ?