Problem with SELECT with specific duplicates

• indoctrine 49919

  Newbie

  Points: 9

  More actions

  July 1, 2014 at 5:25 am

  #308683

  Hello

  I have question, how to make it works:

  I have table with four columns:

  ID_PLACE

  ID_ITEM

  DATE

  ID_USER

  14301.01.2010100

  14401.01.2010100

  15501.01.2010100

  16601.01.2010100

  24301.01.2010100

  24401.01.2010100

  25501.01.2010100

  26601.01.2010100

  34301.01.2010100

  34401.01.2010100

  35501.01.2010100

  36601.01.2010100

  44301.01.2010200

  44401.01.2010200

  45501.01.2010200

  46601.01.2010200

  54301.01.2010100

  54401.01.2010100

  55501.01.2010100

  56601.01.2010100

  I need get information of ID_ITEMS assigned to each ID_USER, without worrying about ID_PLACE. Such like this:

  ID_ITEM DATAID_USER

  4301.01.2010100

  4401.01.2010100

  5501.01.2010100

  6601.01.2010100

  4301.01.2010200

  4401.01.2010200

  5501.01.2010200

  6601.01.2010200

  I cannot DISTINCT ID_PLACE, because it will cut off much more than needed.

  Can someone help me? 🙂

• Phil Parkin

  SSC Guru

  Points: 247202

  More actions

  July 1, 2014 at 5:33 am

  #1726121

  Have you tried

  SELECT DISTINCT ID_ITEM, DATE, ID_USER

  ?

  ---