SELECT Distinct([Currency]),MAX([TimeStamp]),[Rate] FROM [DB_SchoolManager].[dbo].[tbl_Currencies] group by [Currency],[Rate]
USE [DB_SchoolManager]; --Using MAX + GROUP BY SELECT T.* FROM tbl_Currencies AS T INNER JOIN ( SELECT Currency, MAX([TimeStamp]) AS [TimeStamp] FROM tbl_Currencies GROUP BY Currency ) AS H ON T.Currency = H.Currency AND T.[TimeStamp] = H.[TimeStamp] --Using ROW_NUMBER() inline function SELECT T.* FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY Currency ORDER BY [TimeStamp] DESC) AS Rn FROM tbl_Currencies ) AS T WHERE T.Rn=1
USD 2019-01-06 1057.5 LPB 2019-01-06 1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)