Which one is better Distinct or Group By?
655429May 28 2009 — edited May 29 2009Which one is better performance vise?
Select A.aa,B.bb,C.cc
From A,B,C
Where A.aa = B.aa and A.cc = C.cc
Group By A.aa,B.bb,C.cc
OR
Select DISTINCT A.aa,B.bb,C.cc
From A,B,C
Where A.aa = B.aa and A.cc = C.cc