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