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
What is the datatype of image?
What is the limit of mysql database?
What storage engines are used in MySQL?
How do you use auto increment?
What is longblob?
What are the advantages of mysql in comparison to oracle?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
Is mysql free for commercial use?
Is mysql a good database?
How important is to list the column names when doing an insert?
How do I start mysql in mysql workbench?
How to increment dates by 1 in mysql?
What is the purpose of using a heap table?
Who developed mysql?
How many mysql connections can handle?