Select statement that will only take the last submitted entry of it's kind in a certain column.

2001-01-18 Thread Muscarello, Roger
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

MAX record on GROUPS

2001-01-18 Thread Muscarello, Roger
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 *.