Re: SQL question: SELECT and GROUP BY in Oracle8

Problem solved! In comp.databases.theory, J Hidders kindly gave the following solution. It works on both platforms:
SELECT *
FROM revisions r1
WHERE r1.rev IN ( SELECT MAX(r2.rev)

                  FROM revisions r2
                  WHERE r1.firstid = r2.firstid );

Matti

--