What is the differnce between Order by and Group by
Answer Posted / guest
Order by is to sort the output records based on some
columns and group by is to group the records and to apply
aggregate functions on the particular columns
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
How to do Data size testing? Who does this testing (Developer or tester)?
Write a query to get maximum and second maximum in oracle?
what is rcp,if rcp disabled what happen?
WHAT IS CARDINALITIES OF JOIN?
Which three commands cause a transaction to end?
What are different types of data models available? Explain with example?
What is a Transformation?
Data structure used to implements a menu:
What are the advantages of views in a database?
What does specialization in DBMS mean?
How to shrink a database?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
Explain the field term used in database.
Explain buffer manager?