Complex SQL syntax

• Matthew-12035

  Right there with Babe

  Points: 735

  More actions

  November 14, 2001 at 2:06 pm

  #63908

  I have a table "customers" with 2 fields: "ID" and "Name"

  there are multiple rows in this table with the same ID, and different Names.

  Example:

  ID Name

  ---------------

  201 M. Mamet

  201 Matthew Mamet

  How do i write -ONE- SQL statement that gets me a list of names for distinct IDs?

  I don't care which name it pulls, I just want a list of 1 name for 1 ID.

  Thanks!

  Matthew

  
  
  Matthew Mamet

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  November 14, 2001 at 4:09 pm

  #420105

  select id, name = max(name)

  from tbl

  group by id

  
  Cursors never.
  DTS - only when needed and never to control.