What is the difference between GROUP BY and ORDER BY in
Sql?
Answer Posted / jagadeesh
Groupby: It is a way to sub-total your results,or perform
some other 'aggregate' functions on them.
Orderby: It is a simply a way to sort your results. It
doesn't affect what shows up in your result set,only what
order it is displayed.
| Is This Answer Correct ? | 228 Yes | 35 No |
Post New Answer View All Answers
How can you validate emails using a single query?
What is int mysql?
How many sql dml commands are supported by 'mysql'?
How to show table names with 'mysqlshow'?
what is mysql optimization in brief?
what is the default port for mysql server? : Mysql dba
How To see all the tables from a database of mysql server.
What is horizontally scalable?
How would concatenate strings in mysql?
Is mysql a server or database?
Write a query to fetch duplicate records from a table using mysql?
Difference between CHAR and VARCHAR?
How do you say mysql?
What is the maximum no of columns a table can have?
What is 'mysqlimport'?