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


Please Help Members By Posting Answers For Below Questions

Under which circumstance should you create an index on a table?

867


What are the tools used for backup and ticketing?

749


What do you mean by cluster and non cluster index?

775


How heap is implemented in database?

865


give a simple example of physical and logical data independence

2301


What is global database name?

733


Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

1760


Can a database table exist without a primary key?

693


Explain the field term used in database.

720


can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2297


What is Data Modelling?

823


Explain phantom deadlock?

973


Explain entity type?

780


What is the best database software for small businesses?

678


What do you mean by database?

768