What is the difference between GROUP BY and ORDER BY in
Sql?

Answer Posted / lalitha

In Group By clause the results are displayed in group wise
manner means it group all the records in a relation together
and then displayed them for a selected set of fields from
the relation and in Order By clause the results are
displayed in some specified order

Is This Answer Correct ?    55 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of i-am-a-dummy flag in mysql?

552


Why do we use mysql?

479


How does mysql store data?

514


How do you stop an access query?

486


What is schema in mysql?

489






How to show all tables with 'mysql'?

518


Where’s database data actually stored? Is there a way to see the files which are stored?

497


What is the difference between unix timestamp and mysql timestamp?

510


Can we store pdf files in mysql?

464


Can we rollback truncate in mysql?

512


Is mysql a dbms?

481


What is mysql workbench used for?

504


What is inner join in mysql?

463


How can we optimize stored procedure?

480


What is MySQL?

565