Dedup Poll Responses

SELECT
emailAddress, Answer, datestamp

FROM (
SELECT
DISTINCT emailAddress, Answer, datestamp,

ROW_NUMBER() OVER(PARTITION BY emailAddress ORDER BY datestamp DESC) as RowNum

FROM I220040_Polling_Subindustries

)


t2

WHERE RowNum = 1