Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    2

    Unanswered: Can anyone help with this problem?

    Can anyone help with this problem?

    http://www2.gi-bon.sk/problem.html

  2. #2
    Join Date
    Jun 2005
    Posts
    23
    Try this, for mysql 4.1.x
    Code:
    SELECT
     row_id,
     doc_id,
     version,
     body
    FROM
     documents d
    WHERE row_id=
      (SELECT
         MAX(row_id)
         FROM
         documents d1
         WHERE d1.doc_id=d2.doc_id)

  3. #3
    Join Date
    Sep 2005
    Posts
    2
    thanks for reply, tombell

    it works!

    (it didn't work on mysql 4.0.x, then i installed mysql 5.0.x and your solution worked exactly as i wanted to)

    thanks.

Posting Permissions

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