LIMIT CLAUSE

SYNTAX | EXAMPLE | PRACTICE YOURSELF

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

PRACTICE YOURSELF