Interested to Buy Any Domain ? << Click Here >> for more details...
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
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is cursor stability in db2?
What os does db2 run on?
How to find schema of a table in db2?
How can record locking be achieved in those DB2 versions which do not support it?
Name the various locking levels available?
What is a db2 tablespace?
Is ibm db2 open source?
How will you return the number of records in table?
How to compare data between two tables in db2?
Explain in brief how does db2 determine what lock-size to use?
Explain packages.
What is schema in db2?
Why cursor is used in db2?
What are host variables in db2?
