Tsql - delete the last row

Question

I want to remove the last row from a table that satisfies some condition.

DELETE TOP 1 FROM SOME_TABLE
WHERE SOME_COULMN = @VALUE
ORDER BY 1 DESC

Answer 1

DELETE FROM SOME_TABLE
WHERE UNIQUE_ID = 
(SELECT TOP 1 UNIQUE_ID
FROM SOME_TABLE
WHERE SOME_COLUMN = @VALUE
ORDER BY SOMETHING DESC)

Answer 2

DELETE and UPDATE statements require parentheses () for the number of rows arguments

DELETE TOP (1) FROM SOME_TABLE WHERE SOME_COULMN = @VALUE ORDER BY 1 DESC