Comments by Elldubzz (Top 2 by date)

As I am totallY hopeless at sql please could you help me with the actual code. I've tried the following but there is an issue with the syntax:
SELECT MAX([Effective Date] AS MaxAddressDate
FROM [Person].[Details]
GROUP BY [Person Number]
ORDER BY [Person Number] DESC

OR

SELECT MAX (Effective Date) AS 'Max Date'
FROM Person.[Details]
GROUP BY [Person Number]
ORDER BY [Person Number] DESC