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 processlist in mysql?

498


Is null in mysql?

452


What is mysql aggregate functions? Explain

533


Do you need a license for mysql?

516


How do I grant privileges to a user in mysql phpmyadmin?

479






What is data type for image in mysql?

459


What is 'mysqlshow'?

640


What are the 5 r's of managing behaviors?

621


What is the full form of mysql?

519


How to run 'mysql' commands from a batch file?

498


How many rows can be inserted in mysql at a time?

499


How is mysql database stored?

537


Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1000


Which is faster mongodb or mysql?

458


using primary can we relate two table, with out foreign key?

2295