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

Explain different types of locks in sql server.

0 Answers  


What are the different Topologies in which Replication can be configured?

0 Answers  


What is optimization and its types?

0 Answers  


What is index fragmentation in ms sql server?

0 Answers  


How to apply cascading referential integrity in place of triggers?

0 Answers  


If we use where clause in the left outer join then how the query would behave/act?

1 Answers  


What is Covering Indexes? Plz explain with example

3 Answers  


Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  


What happens if ntwdblib.dll is missing on your machine?

0 Answers  


What is a sub-query? When would you use one?

3 Answers  


What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,


UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,


Categories