Interested to Buy Any Domain ? << Click Here >> for more details...
difference between group clause and order clause
- 1 Answers
- 5220 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the use of COMMAREA ?Minimum how much data we can pass from it?
what is the input to PLAN? what is the input to DBRM?
Why use RUNSTAT Utility?
Where could you look if you had a question about whether a column has been defined as an index?
How can you count the number of rows from a table tab?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
How do I start db2 in windows?
What is a cursor in programming?
What is difference between *omit and *nopass?
What is package in db2 mainframe?
What is the function of the Data Manager?
What are the contents of a dclmgen?
COBOL 
