Interested to Buy Any Domain ? << Click Here >> for more details...
difference between group clause and order clause
- 1 Answers
- 5230 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 the cascade rule and how does it relate to deletions made with a subselect?
What is db2 bind?
how can we find nth max salary from A table
Explain the benefits you can get from mainframe connect?
What are catalog tables in db2?
What parameters are used to control the free space in DB2?
How to design maps
How do I import data from excel to db2?
Write a query to retrive partial string.
what happend with out using Commit,when closing cursor and program?
what is static sql? what is dynamic sql? Give me details
How can we define a table? How can we apply SEARCH ALL on it ?
COBOL 
