Can anyone help with this problem?

Chupacabras · #1 (**permalink**) 09-27-05, 10:27

Can anyone help with this problem?

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

tombell · #2 (**permalink**) 09-27-05, 11:12

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)

Chupacabras · #3 (**permalink**) 09-28-05, 06:51

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech