Interested to Buy Any Domain ? << Click Here >> for more details...
difference between group clause and order clause
- 1 Answers
- 5120 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 reorg and runstats in db2?
What's the difference between DB2 active log and archive log? Thanks a lot...
What are union and union all?
What is release/acquire in bind?
What is db2? Explain.
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
How to find schema of a table in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
How to resolve -502 sql code in DB2?
What is null in db2?
What is buffer pool in the db2 database?
COBOL 
