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

©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin