Your First Query

USE AdventureWorksDW2019MSDS

SELECT *
FROM dw.DimEmployee
WHERE 1 = 1
AND IsMostRecentRecord = 1

SELECT FirstName, LastName
FROM dw.DimEmployee
WHERE 1 = 1
AND IsMostRecentRecord = 1

SELECT LastName, FirstName
FROM dw.DimEmployee
WHERE 1 = 1
AND IsMostRecentRecord = 1