LIMIT CLAUSE
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.
SYNTAX
Where,
-
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.
EXAMPLE
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;
PRACTICE YOURSELF
Want More SQL Deep Dives