MS SQL Server how to pull the last row correctly?

Question

SQL Server

Hello,
I just started working with MSSQL Server, I need to pull out the last record in the query, I do it like this:

SELECT text FROM table WHERE user_id=5 ORDER BY id DESC LIMIT 1

Thank you very much in advance!

Answer 1

SELECT top 1 text FROM table WHERE user_id=5 ORDER BY id DESC
LIMIT not supported on older servers