Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between GROUP BY and ORDER BY in
Sql?
- 12 Answers
- 79026 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 do I know if mysql is running on windows?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
What is the difference between BLOB AND TEXT?
Write a command to view mysql database table structure?
How do I find mysql location?
How to update info already in a table and delete a row(s) from a table.
Can we write pl sql mysql?
What language is mysql written in?
what is database black box testing? : Mysql dba
What is myisamchk?
What does schema mean?
what is constraints? Also explain the different types of constraints?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
How many primary keys can be there in a table?
How to display nth highest salary from a table in a mysql query?
