Avatar of mgordon-spi

asked on 

Max ID per user from table

I have a table that has multiple rows per user, I need to get a list of the last ID per User.

SELECT        ID, ProjectID, UserID
FROM            tAssessments
WHERE        (ProjectID = 1)
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008

Avatar of undefined
Last Comment

8/22/2022 - Mon