Interested to Buy Any Domain ? << Click Here >> for more details...
difference between group clause and order clause
- 1 Answers
- 5304 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 are PACKAGES ?
What is the maximum length of sqlca?
What is the logical entity between plan and Package?
What is ibm db2 client?
What is Skeleton cursor table (SKCT)?
how to fetch multiple records without using cursor
Where do you specify them?
How to design maps
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is load replace in db2?
B37 abend during spufi?
What is netezza database?
COBOL 
