What is the difference between Where and Having Clause
Answer Posted / badal
both define condition
where for individiual records
group by for group of records
| Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is image copy in db2?
How to check last update on table in db2?
Can one database have multiple instances?
Which component is responsible for processing sql statements and selecting access paths?
Which are the db2 tools to protect integrity of the database?
How to connect to db2 database from windows command line?
What is the use of with ur in db2?
What is the difference between drop table and delete table?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Why do chiropractors use drop table?
What is the usage of open cursor command?
What is multi row fetch in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.