I have a table called CONTENT. Columns called ID (primarykey), DOCUMENT
(varchar(50)), DESCRIPTION (text). People submit files to our intranet and
we collect info. about them in this table. If people have made changes to
the doc. they just resubmit it to the intranet. So there can be many
This gives me one instance of each file name in the DOCUMENTS column
submitted into the database. The only thing though is it gives me the
oldest of the file name in the DOCUMENTS column which are submitted. Any
ideas how to get the newest one? I've tried adding: , MAX(ID) after the
SELECT *.