SQL Server - Select Top N

 Select Top N from SQL Server

Oracle RowNum pseudocolumn.

SQL Server and Oracle allow you to run a Select Statement, but limit the
number of rows returned.  This is very useful if you just need to see a
snapshot of the data on a table with a large number of records.

SQL Server:

SELECT TOP 100 FIELD1, FIELD2, FIELD3 FROM TABLE

Oracle:

SELECT FIELD1, FIELD2, FIELD3 FROM TABLE WHERE ROWNUM <= 100;