Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between GROUP BY and ORDER BY in
Sql?
- 12 Answers
- 78509 Views
- Creative, Renault Nissan, Trikon Networks, I also Faced
- E-Mail Answers
Answer Posted / haritharavi
Order by clause is used to sort the rows in ascending or
descending order.Group by clause is used to sort/group a
number of rows together so as to apply aggregate functions.
So order by is only to sort the records where as group by
is to sort and find aggregate functions of each group.
| Is This Answer Correct ? | 32 Yes | 5 No |
Post New Answer View All Answers
How will show all records containing the name "sonia" and the phone number '9876543210'
How would you enter characters as hex numbers?
What, if a table has one column defined as TIMESTAMP?
What is mysql_query?
What is 'mysqld'?
What is delimiter in mysql?
What language does mysql use?
What is a crosstab query?
What is regexp?
How do I create a database in mysql workbench?
What is a query in mysql?
Is mysql an oracle product?
How to enable or disable a row of a table using MySQL in struts?
What is the difference between b-tree and hash indexes?
What is the default port of mysql server?
