Limit record like ROWNUM in MS SQL server 2000 - Stack Overflow

I want to know how to limit records in SQL Server 2000. ... For SQL Server: SELECT TOP(10) * FROM tbl.

stackoverflow.com