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 are the benefits of mysql?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
How to convert character strings to dates?
What is mysql in dbms?
How do I install mysql on windows 7?
What is the difference between myisam dynamic and myisam static in mysql?
What are string data types?
Is mongodb faster than mysql?
What is an example of a delimiter?
What does "i_am_a_dummy flag" do in mysql?
How do I show all mysql databases?
What is use of mysql?
How to find the unique values if the value in the column is repeated?
Is mysql a scripting language?
What is a tinyint?