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
What are the disadvantages of views in a database?
Data structure used to implements a menu:
What is a Transformation?
Why do we need distributed database?
Explain data independence & its types.
What is a driver in database?
How to produce such kind of file?
How much does it cost to build a database?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
Explain the various types of normalization.
How does non-cluster index functions?
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
What are different types of joins used in?
What are the concurrency problems a database faces?
How to do performance tunning a database in DB2 V8.2 UDB in linux