this query does not give error that invalid column name it gives an error invalid syntax error near where
so right query is it should be working fine.
SELECT *
FROM(
SELECT *,
ROW_NUMBER() OVER(PARTITION BY NAME ORDER BY code) AS Rowno
FROM TableName
) AS t1
WHERE Rowno = 1