Interested to Buy Any Domain ? << Click Here >> for more details...
difference between group clause and order clause
- 1 Answers
- 5299 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 |
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
Define buffer pool.
What is the use of COMMAREA ?Minimum how much data we can pass from it?
what is plan? is plan executable or package?
What are packages in db2?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
Why do we use cursor?
How to execute stored procedure in db2 command editor?
What is a recovery log?
what are the bind parameters?
What is release/acquire in bind?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
COBOL 
