Learn SQL Database Programming

Limiting results on other Relational Database Management Systems (RDMSes)

For Oracle, you can do the following:

You can limit rows as follows:

SELECT playerid, g_all, g_batting, g_defense FROM appearancesOFFSET 0 ROWS FETCH NEXT 500 ROWS ONLY;

If you would also like to offset rows, you can execute the following query:

SELECT playerid, g_all, g_batting, g_defense FROM appearancesOFFSET 500 ROWS FETCH NEXT 1000 ROWS ONLY;

There are a couple of ways you can limit rows returned in SQL Server. You can use TOP, as shown in the following query:

SELECT TOP 500 playerid, g_all, g_batting, g_defense FROM appearances;

You can also limit rows like so:

SELECT playerid, g_all, g_batting, g_defense FROM appearancesORDER BY playeridOFFSET 0 ROWS FETCH ...