Interested to Buy Any Domain ? << Click Here >> for more details...
difference between group clause and order clause
- 1 Answers
- 5221 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 null indicator in cobol db2?
What is syscat in db2?
What is a LIKE table and how is it created?
What is the role of the data page in the db2 database?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
When do you specify the isolation level?
what are stage one indexable predicates?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
COBOL 
