Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2012
    Posts
    2

    Unanswered: Returning a list of different column values

    My table has a column called Period i want to get a list of different periods example:
    Period
    1
    2
    31
    1
    2
    4
    12
    31
    2

    then run an sql statement and should return you the following
    Period
    1
    2
    4
    12
    31

    please help me with the sql statement

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    See the Help file for the DISTINCT keyword.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  3. #3
    Join Date
    Sep 2012
    Posts
    2
    i feel silly after looking at the word thanks

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    You're welcome!

    These things are sometimes obvious with hindsight.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •