What is the use of Limit in SQL?

Question

Hi  I have a query select * from login order by UserID desc limit 2; But it shows that Incorrect syntax near 'limit'. Please help me. Thanks

Abhay Shanker · Answer

Limit is supported in Mysql not in SQL Server. So you need to modify your query as below select TOP 2 * from login order by UserID desc

Munesh Sharma · Answer

Sql Server does not support Limit keyword.It use Top keyword. SELECT TOP number | percent column_name(s) FROM table_name ; mysql support Limit keyword SELECT column_name(s) FROM table_name LIMIT number ; you use this query and run it select TOP 2 * from login order by UserID desc