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 a db2 tablespace?
What is the physical storage length of timestamp data type?
How to find schema of a table in db2?
What is temporal table in db2?
What are the 2 sqlcodes that are returned?
What is the difference between plan and package in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Is it possible using max on a char column?
What are the contents of dclgen?
How to rename a table in DB2 ?
What is sqlca?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is role in db2?
How do I delete a table in database?
Explain about rct.