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
What is difference between mysql_connect and mysql_pconnect?
How do I start mysql database?
How to extract a unit value from a date and time?
How to returns the columns and column information pertaining to the designated table.
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
List data types in mysql? Explain
What command is used to delete the data from the table without deleting the table structure?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
What is difference between mysql and mysql server?
How to enter binary numbers in sql statements?
How do I connect to a database in mysql workbench?
What is heap table?
How to use mysqldump to create a copy of the database?
How is mysql database stored?
What is tee command in mysql?