Results 1 to 3 of 3

Thread: select help.

  1. #1
    Join Date
    Apr 2004
    Posts
    101

    Unanswered: select help.

    Hi,
    Here is my result set..

    ID NAME STATUS
    1 AAA 1
    2 AAA 2
    3 BBB 1

    I wanted to get the result like this

    1 AAA 1
    3 AAA 1

    In otherwords i want to eliminate repeated names from my result set..
    thanks

  2. #2
    Join Date
    Apr 2004
    Posts
    101
    let me add more into it..
    i don't want to compare status column in my select statement.
    all i'm looking is any function like select top()

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    woooosh

    Man am I confused... how do you get 3 BBB 1?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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