Sql Server does not have a LIMIT functionality. You can use TOP.

Code:
select TOP 5 * from Table1