Answer Posted / sathy
group by clause is used to group the column values using
corresponding column values
group by cannot use where condition, instead of where it can
use having which has same function as where
order by is used to order the records in order ie.,
ascending or descending.
order by can use where, but not having having is only for
group by.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What does db2 mean?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Why do we use cursor?
What is bind and rebind in db2?
How to find schema of a table in db2?
Explain various types of locks in db2?
What is with ur in db2?
what is a corelated subquerry?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is ibm db2 used for?
Can we insert update delete in view?
What is db2 purescale?
What is database alias db2?
Explain the contents that are a part of dclgen.
What does db2 plan contain?