To fetch limited rows in an SQL server you can use these commands for fetching the data SELECT TOP, LIMIT, and ROWNUM

The number of records to return can be specified using the LIMIT, SELECT TOP, or ROWNUM commands.

Recall that SQL Server uses SELECT TOP. Oracle uses ROWNUM, but MySQL uses LIMIT.