Learn SQL Database Programming

Learning how to use the LIMIT clause

LIMIT is a keyword that, when added to a SELECT statement, will return only a specified number of rows. Sometimes, you may want to see a cross-section of data, so the LIMIT clause, along with OFFSET, will help you accomplish this. For example, if you want to only see the first 500 rows in the appearances tables, you can execute this query:

USE lahmansbaseballdb;SELECT playerid, g_all, g_batting, g_defense FROM appearancesLIMIT 500;

This query will return the first 500 rows with the specified columns in the appearances table, as shown in the following screenshot:

If you want to display the rows starting ...