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 difference between order by and group by?

Answer Posted / Sudhir Kumar Trivedi

In SQL Server, 'order by' sorts the result set in ascending or descending order. 'Group by', on the other hand, groups rows that have the same values in specified columns and performs aggregation operations (such as sum, count, etc.) on each group.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of constraints?

981


Why use identity in sql server?

1185


What is a coalesce function?

1261


What is clustered index

1069


Disadvantages of the indexes?

1205


How do I create a trace in sql server?

1102


What are the different SQL Server Versions you have worked on?

1071


Is it possible to have clustered index on separate drive from original table location?

1026


Can one drop a column from a table?

1075


How can I check that whether automatic statistic update is enabled or not?

1101


What is sql server query analyzer?

1111


What are the different subsets of sql?

1633


What is the difference between upgrade and migration in sql server?

1163


do you know how to configure db2 side of the application? : Sql server database administration

1106


When should you use an instead of trigger?

1033