Distinct and Group by

• lindss01

  SSCrazy

  Points: 2264

  More actions

  February 2, 2006 at 11:23 am

  #91491

  If you have a query like

  SELECT Distinct Person_Name, Count(*) From Person_table

  Group BY Person_Name   (Thanks Mathew!)

  does the Distinct do anything?  I know the results are the same with and without the Distinct, but does it add anything behind the scenes?  The executiuon plans seem to be the same.

   

  Steve

• Mathew J Kulangara

  SSCommitted

  Points: 1610

  More actions

  February 2, 2006 at 11:40 am

  #618466

  I don't believe so.

  Of course I assume you mean..

  SELECT Distinct Person_Name, Count(*) From Person_table

  Group BY Person_Name

  ---

  Mathew J Kulangara
  sqladventures.blogspot.com