Select the latest record in the list by date

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