Forum Child: CREATE TABLE [dbo].[Forum_Child]( [ID] [int] IDENTITY(1,1) NOT NULL, [PID] [int] NOT NULL, [Post] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [DateSubmitted] [datetime] NOT NULL, [Submitter] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] this is a child table to Forum with PID being the Foreign Key. It is a one to many relationship. For each post in the Forum table, I can have 0-many replies in this child table. How do I write a query to select the most recent record for each unique PID. I want a maximum of one record per PID and I want it to be the most recent. For example: Select TOP 1 * From Forum_Child where PID = 3 ORDER BY DateSubmitted DESC except this only returns the most recent child record for Post 3. I want a query that will give me this result for each distinct PID in the table Any Ideas?