Ms Sql Query

[mbarnes2231]

I am trying to write a query that will choose a row without duplicates. The table is used as a checking in/out log and I need to query the latest check in or out. There is a column that is in date-time format that records the time of the check in or out, so inside of my query, how can I grab all of the distinct rows, choosing the latest check in or out transaction for each user?

[mllin1234]

I am trying to write a query that will choose a row without duplicates. The table is used as a checking in/out log and I need to query the latest check in or out. There is a column that is in date-time format that records the time of the check in or out, so inside of my query, how can I grab all of the distinct rows, choosing the latest check in or out transaction for each user?

Please try this in SQL 2005

WITH [TEMPTABLENAME] AS
(SELECT ROW_NUMBER() OVER (PARTITION BY user ORDER BY loginout_dateti me desc) AS ROWID, * FROM logtablename)
SELECT user,loginout_d atetime FROM [TEMPTABLENAME] WHERE ROWID=1