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 distinct clause and group by
clause?

Answers were Sorted based on User's Feedback



What is the difference between distinct clause and group by clause?..

Answer / swamy

Distinct Clause:
---------------
Distinct Clause Will Eliminate the Duplicate data or Rows
when u r selecting from table .So it Produce the Data or
Rows with out Duplication.Generally Distinct Clause will
be Placed on the Column of the Table.

Group Clause:
-------------
Group Clause will group or pack the rows or data based on
the Column(S).

Is This Answer Correct ?    24 Yes 5 No

What is the difference between distinct clause and group by clause?..

Answer / rkvenky

distinct suppress the duplicates of data in the select stmt.
where as group by combines the data which we willgive in
order.
2.group by used at the end of select stmt
distint used in select stmt to columns
3.
group by is function where distinct is keyword

Is This Answer Correct ?    8 Yes 13 No

Post New Answer

More SQL Server Interview Questions

What are “lost updates”?

0 Answers  


how to avoid cursors? : Sql server database administration

0 Answers  


What are the different types of replication are there in sql server 2000?

0 Answers  


Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,


What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  


Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,


While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  


How to compare the top two records using sql?

0 Answers  


why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  


Can we do dml on views?

0 Answers  


what is call by value & call by reference ?

2 Answers   Cap Gemini,


Categories