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
What is mysql command line?
What is database in php mysql?
What is database clustering in mysql?
How to calculate the difference between two time values?
What is pdo connection?
Does mysql automatically index foreign keys?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
What are the disadvantages of mysql?
How to display odd rows in student table in mysql?
What does mysqli_fetch_assoc do?
How do you rename a procedure in mysql?
What are the advantages/disadvantages of mysql and php?
Is there a free version of mysql?
What is 1nf 2nf 3nf?
What is mysql aggregate functions? Explain