Select Most Recent States From History Table Select Most Recent States From History Table sql sql

Select Most Recent States From History Table


sql tsql

SQL Server 2005 (onwards):

WITH MostRecentRows AS(    SELECT ID, Name, Data,    ROW_NUMBER() OVER (PARTITION BY Name ORDER BY TimeStamp DESC) AS 'RowNumber'    FROM MySchema.MyTable) SELECT * FROM MostRecentRows WHERE RowNumber = 1

sql tsql

Assuming there are no duplicate timestamps per name, something like this should work:

SELECT ID, Name, Timestamp, DataFROM test AS oWHERE o.Timestamp = (SELECT MAX(Timestamp)                     FROM test as i                     WHERE i.name = o.name)

sql tsql

SQL Server 2000:

SELECT  ID, Name, Timestamp, DataFROM  DataTable  INNER JOIN  (     SELECT ID, MAX(Timestamp) Timestamp FROM DataTable GROUP BY ID  ) latest ON     DataTable.ID = Latest.ID AND     DataTable.Timestamp = Latest.Timestamp

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last