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


Please Help Members By Posting Answers For Below Questions

What are the benefits of mysql?

478


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...

2593


How to convert character strings to dates?

541


What is mysql in dbms?

491


How do I install mysql on windows 7?

484






What is the difference between myisam dynamic and myisam static in mysql?

499


What are string data types?

578


Is mongodb faster than mysql?

507


What is an example of a delimiter?

498


What does "i_am_a_dummy flag" do in mysql?

503


How do I show all mysql databases?

512


What is use of mysql?

499


How to find the unique values if the value in the column is repeated?

562


Is mysql a scripting language?

478


What is a tinyint?

513