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
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
What are the functions of mysql?
What is innodb mysql?
What you can use regular expression for in mysql? Support your answer with an example?
How can we encrypt and decrypt a data presented in a table using mysql?
Why do we use pragma autonomous transaction?
How do I find mysql location?
How to update database permissions/privilages.
How to see table's field formats or description of table .
Which mysql function is used to concatenate string?
How can I create table in mysql?
What is the purpose of using a heap table?
How do I start mysql in mysql workbench?
Write a query to create a database and a table?
How to dump a table to a file with 'mysqldump'?