Wherever we have large tables with thousands of records we can use LIMIT Clause.
It limits the number of records in the query result set.
SELECT : keyword used to fetch limited records in a table.
Table_name : The name of the table from where you want to fetch the data
LIMIT : keyword used to limit the number of records in a table.
Let’s query PersonalInfo table in our Demo Database to fetch only 2 records.
Figure 40.1. SELECT * FROM PersonalInfo
Figure 40.2 Select * from PersonalInfo LIMIT 2;
Want More SQL Deep Dives