Create a SQL query to retrieve most recent records

by

Aggregate in a subquery derived table and then join to it. 

 Select Date, User, Status, Notes 
    from [SOMETABLE]
    inner join 
    (
        Select max(Date) as LatestDate, [User]
        from [SOMETABLE]
        Group by User
    ) SubMax 
    on [SOMETABLE].Date = SubMax.LatestDate
    and [SOMETABLE].User = SubMax.User

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. How do I UPDATE from a SELECT in SQL Server?
  3. Get top 1 row of each group
  4. How to return only the Date from a SQL Server DateTime datatype
  5. Referring to a Column Alias in a WHERE Clause
  6. Function vs. Stored Procedure in SQL Server
  7. Generate a resultset of incrementing dates in TSQL
  8. converting Epoch timestamp to sql server(human readable format)
  9. Better techniques for trimming leading zeros in SQL Server?
  10. How do I split a delimited string so I can access individual items?
  11. Common Table Expression, why semicolon?
  12. What’s the best way to select the minimum value from several columns?
  13. T-SQL split string based on delimiter
  14. Using ISNULL vs using COALESCE for checking a specific condition?
  15. Counting DISTINCT over multiple columns
  16. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  17. Why use Select Top 100 Percent?
  18. How to check if a stored procedure exists before creating it
  19. Correct use of transactions in SQL Server
  20. Can an INNER JOIN offer better performance than EXISTS
  21. Find the real column name of an alias used in a view?
  22. Stored procedure that exports data into csv files only exports to one file
  23. Get Start and End Date from Week Number SQL Server
  24. Get the last day of the month in SQL
  25. How to create a pivot query in sql server without aggregate function
  26. SQL take just the numeric values from a varchar
  27. SQL Server FOR XML Path make repeating nodes
  28. Why is RAND() not producing random numbers?
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment