difference between group clause and order clause
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 |
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What is image copy in db2?
Where can you declare a cursor in a cobol-db2 program?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What are iseries servers?
What is the difference between plan and package in db2?
What is role in db2?
How many databases can be created inside an instance in db2 ?
wht is d/f between union and joins ?
select 100 records from million records ?
What is a cursor?
what's the error code for Unique Index Violation?