What is the difference between GROUP BY and ORDER BY in
Sql?
Answer Posted / jagadeesh
Groupby: It is a way to sub-total your results,or perform
some other 'aggregate' functions on them.
Orderby: It is a simply a way to sort your results. It
doesn't affect what shows up in your result set,only what
order it is displayed.
Is This Answer Correct ? | 228 Yes | 35 No |
Post New Answer View All Answers
How do you insert a table?
How many ways we can retrieve the date in result set of mysql using php?
What are the objects can be created using CREATE statement?
What are the disadvantages of stored procedures?
How to decrement dates by 1 in mysql?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
How do I install mysql workbench?
What are the differences between char and nchar?
What is difference between mysqli and pdo?
What are the advantages and disadvantages of using mysql?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
What are federated tables?
What is a definer?
how to connect a php script with the mysql database?
How to change a password for an existing user via mysqladmin?