Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between GROUP BY and ORDER BY in
Sql?
- 12 Answers
- 79353 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
How to get nth highest salary from table in a mysql?
How to drop an existing index in mysql?
In how many ways we can retrieve data in the result set of mysql using php?
How to rename an existing table in mysql?
What is information_schema in mysql?
What is the difference between mysql and pdo?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
Why do we use preparedstatement?
How do I delete a mysql user?
What does "i_am_a_dummy flag" do in mysql?
Is mysql a free database?
what is the default port for mysql server? : Mysql dba
How do I disconnect mysql workbench?
Is mysql free software?
Is mariadb better than mysql?
