What is the difference between group by and order by?
Answer Posted / sunil1405
Group By controls the presentation of rows , order by
controls the presentation of columns.
| Is This Answer Correct ? | 15 Yes | 7 No |
Post New Answer View All Answers
How to access db2 tables in mainframe?
Explain in detail about buffer manager and its functionalities?
What is the use of with ur in db2?
What language is db2 written in?
What is the picture clause of null indicator variable?
What is access path in db2?
What is dbrm? What it contains? When it will be created?
What is lock escalation in db2?
Why do chiropractors use drop table?
How to retrieve rows from a db2 table in embedded sql?
How to execute stored procedure in db2 command editor?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the use of predicate?
Is it possible using max on a char column?
can all users have the privilage to use the sql statement select * (dml)?