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

Answer Posted / ranjani

groupby is used to show the table in ascending order
where as orderby is used to show the table in any order or
same order.

Is This Answer Correct ?    9 Yes 66 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dblink?

483


how to take mysql database backup?

579


How can you export the table as an xml file in mysql?

503


What is a session in mysql?

487


What mysql means?

493






What is definer in mysql trigger?

497


How do you create a new database in mysql?

464


What is difference between oracle and mysql?

497


What is processlist in mysql?

497


Which datatype is used for email in mysql?

483


How many columns is too many mysql?

474


How do I restore a mysql database dump file in linux?

490


Why mysql is so popular?

515


How can I remotely connect to mysql database?

451


Write a query to count the number of rows of a table in mysql.

481