#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Newfoundland, Canada
    Posts
    102
    Rep Power
    12

    List unique values from column


    I'm trying to figure out a SQL command that is like
    Select ColumnX from TableX
    except I just want the list of values in ColumnX, so if ColumnX has multiple entries with values "X" and multiple entries with values "Y", the Select command will only return "X" and "Y". Does that make sense???

    Any help is appreciated.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    Paris Uppland
    Posts
    2,383
    Rep Power
    391
    Code:
    Select Distinct ColumnX from TableX
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Newfoundland, Canada
    Posts
    102
    Rep Power
    12
    Perfect! Thank you

IMN logo majestic logo threadwatch logo seochat tools logo