Results 1 to 2 of 2

Thread: Sql .....Select

  1. #1
    Join Date
    Aug 2004
    Posts
    77

    Unanswered: Sql .....Select

    This is my table
    Co Name Count
    522 Ja 4
    522 Ho 4
    528 Ri 5
    123 Jame 1
    123 Timmy 1
    678 Nu 7

    The result that I am trying to do is

    522 Ja 4
    528 Ri 5
    123 Jame 1
    678 Nu 7

    In other word, I want the value that is duplicated in field Count return just only one...... !! Any comment !!

  2. #2
    Join Date
    Jul 2003
    Posts
    50
    In this case the two rows with "Co" = 522 has two different names, which name should be used?

    If you don't care wich name will be used..... HINT: Use "group by" and "max" in your query.

Posting Permissions

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