Select only Distinct Records

• • Reply

  12 years ago

  by shalinijennifer

  shalini

  , India

  Joined 13 years ago

  Hi ,

  name                     code

  2-Part Finish         114012
  2-Part Finish         114013
  2-Part Finish         114014
  2-Part Finish         114015
  2-Part Finish         114016
  Abrasive Wheel         114018
  Abrasive Wheel         114019
  Abrasive Wheel Kit 114020
  Abrasive Wheel Kit 114021
  Abrasive Wheel Kit 114022

  
  The above is my table format in sql server 2000 db

  I want the output to be of the format as below:

  name                     code

  2-Part Finish        114012
  Abrasive Wheel         114018
  Abrasive Wheel Kit 114020

  
  I want to do it in sql server query analyser only

  Plz help

  Thanks in Advance

  Report abuse
• • Reply

  12 years ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 13 years ago

  SELECT [name], MIN()
  FROM TableName
  GROUP BY [name]
  &nbsp;</p>

  Report abuse