Query Help

[FCC]

Hi all,

I am stumped on how to write query. My table scheme is:

ThreadID | CommentID | CommentDate

So the threadID is the priminary key and comments are added to threads. I want to sort the threadID by the most recent commentDate.

So I figured the query:

SELECT ThreadID, CommentDate FROM Comments ORDER BY CommentDate

This sorta works, but it just returns all the rows sorted by CommentID. I want the ThreadID to be unique and return the most recent comment of that thread.

Any hints on how to do this?

[r937]

I want the ThreadID to be unique and return the most recent comment of that thread.

SELECT ThreadID
     , CommentID 
     , CommentDate 
  FROM Comments as T
 WHERE CommentDate = 
       ( SELECT MAX(CommentID)
           FROM Comments
          WHERE ThreadID = T.ThreadID )
ORDER 
    BY CommentDate