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

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

Question Posted / ruban

2 Answers
15970 Views
HHH, Value Labs, I also Faced
E-Mail Answers

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