Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between GROUP BY and ORDER BY in
Sql?

Answer Posted / jamsheed

Order by keyword is used to sort the result set in asc & desc order.

Group by keyword is used to group the resultset. It is used to find distinct values also.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the datatype of image?

898


What is the limit of mysql database?

907


What storage engines are used in MySQL?

984


How do you use auto increment?

896


What is longblob?

914


What are the advantages of mysql in comparison to oracle?

969


Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

920


Is mysql free for commercial use?

852


Is mysql a good database?

892


How important is to list the column names when doing an insert?

995


How do I start mysql in mysql workbench?

891


How to increment dates by 1 in mysql?

978


What is the purpose of using a heap table?

1022


Who developed mysql?

944


How many mysql connections can handle?

850