Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2013
    Posts
    1

    Unanswered: Access SQL:: Help please :: Urgent

    I Want to select one row from below table like

    Col1 | Col2 | Col3

    a | b | 3.4
    b | a | 3.4
    c | d | 2.5
    d | c | 2.8

    result

    a | b | 3.4
    c | d | 2.5

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    According to what criteria ?
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by Sinndho View Post
    According to what criteria ?
    I'm guessing one per matched pair ie only one of A B and B A
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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