What is the difference between GROUP BY and ORDER BY in
Sql?
Answer Posted / jamsheed
Order by keyword is used to sort the result set in asc & desc order.
Group by keyword is used to group the resultset. It is used to find distinct values also.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Where’s database data actually stored?
What is 'mysqldump'?
How can I create table in mysql?
What are different types of queries?
How large can a mysql table be?
How can I see connections in mysql?
What is information_schema in mysql?
How to use regular expression in pattern match conditions?
What does the file with the extension: frm, myd, and myi contain?
how to add a new column to an existing table?
What is index length in mysql?
How do I find mysql database?
Do while loop in mysql procedure?
What data structure does mysql use?
What are the difference between and myisam and innodb?