Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between GROUP BY and ORDER BY in
Sql?
- 12 Answers
- 79009 Views
- Creative, Renault Nissan, Trikon Networks, I also Faced
- E-Mail Answers
Answer Posted / hareesha k
GROUP BY is used to group values from a column, and, if
necessary, perform calculations on that column. We can use
aggregation functions (e.g. COUNT, SUM, AVG) on the grouped
column.
The result of the GROUP BY is ordered by the column that
grouped.
The ORDER BY clause is used only for ordering(Sorting) the
query results.Asc by default.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is pragma autonomous_transaction?
Can you tell a way to know the number of days between the two given dates in php?
What are the 'mysql' command line arguments?
How to enter boolean values in sql statements?
How can we find out which auto increment was assigned on Last insert?
What is msql?
Where is the mysql database stored?
what is the default port for mysql server? : Mysql dba
Does facebook still use mysql?
How to escape special characters in sql statements?
What is mysql slow query?
What are stored procedures and functions?
What is view? How can you create and drop view in mysql?
What are the benefits of mysql?
How to enter Characters as HEX Numbers?
