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
Why is it called mysql?
What does "i_am_a_dummy flag" do in mysql?
What is the difference between mysql_connect and mysqli_connect?
can you tell what are the different set operations available in mysql? : Mysql dba
What is insert query in mysql?
How many sql dml commands are supported by 'mysql'?
Why we use mongodb instead of mysql?
How can you import tables from a sql file into a database by using the mysql client?
What are the technical specifications of mysql?
How to dump a table from a database.
Write command to import an mysql file?
How do you create a schema?
Why we use mysqli instead of mysql?
How to control the max size of a heap table?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?