Hello,
I have a table PageContent which has the following columns: ContentID (contains the unique id of each page content), Content (contains the page content), Version (a number indicating the version of Content). Since several verions of each ContentID exist, ContentID is repeated in several rows. The Content field is unique for each ContentID but is not necessarily unique across the whole table.

I want to do a SELECT statement that will return ContentID and Content but only show the most recent version of each ContentID. SELECT DISTINCT works for returning each unique ContentID number but since the Content fields are different, I can't use a DISTINCT statement.

Sorry, this is probably pretty simple.
Thanks.
Tony

Just out of curiosity, what is the primary key for this table?

Assuming by using the words "..the most recent version.." you mean the row with the maximum value of the version column for a given ContentID, then a correlated subquery will select those rows:

SELECT ContentID, Content
FROM PageContent P1
WHERE Version = (SELECT MAX(Version) FROM PageContent P2 WHERE P1.ContentID = P2.ContentID)



Jeff Mason
je.mason@comcast.net