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 use of count function in mysql?
Explain Access Control Lists.
Does uninstalling mysql delete database?
What is deterministic in mysql?
How can we get the number of rows affected by query?
Is mysql written in c?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
How do I run mysql?
How can we optimize stored procedure?
How Switch (select or use) to a database.
What is the use of mysqli_fetch_array?
How do I delete a mysql user?
What is “i_am_a_dump” flag in mysql?
Explain about reporting services of MYSQL?
What is the function of myisamchk?