Complex (for me) query

[lcioria]

I have a table which contains a document list. For each document I have an ID
field and a revision field. Revisions start from 0 and go on like 1 2 3 etc
(dah..)

I have to query out a subselection of this table containing every document
only ONE time, in its last revision (highest Revision number)

how can I do it?
thanks

 

[Carl Rapson]

Something like:

SELECT ID,MAX(revision) FROM table GROUP BY ID;

Carl Rapson