Results 1 to 3 of 3

Thread: unique numbers

  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Question Unanswered: unique numbers

    Goodday!
    I've created a table which is filled with a lot of duplicate numbers. Now I need to create a query that selects all the unique numbers from this table.
    i.e.
    kar_nr
    ----------
    1
    1
    2
    3
    3
    4
    4
    4

    the query should return the following:
    kar_nr
    ----------
    1
    2
    3
    4

    Thank you for your help! Have a nice day!
    Elwyn

  2. #2
    Join Date
    Jul 2003
    Posts
    38
    Select Distinct kar_nr from table;

    regards

  3. #3
    Join Date
    Aug 2003
    Posts
    2

    Smile

    Thanks for your quick response! It worked out!
    Originally posted by SubHugo
    Select Distinct kar_nr from table;

    regards

Posting Permissions

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