Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • What is the use of LIMIT Clause in MySQL?

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 391
    Comment on it

    In MySQL, the LIMIT Clause is used to return the specified number of records means by using LIMIT we can specify how many records we want to return from a table..

    The LIMIT Clause is useful when, we want to select some records from a table which has thousands of records.

    LIMIT Clause Syntax

    1. SELECT column_name(s)
    2. FROM table_name
    3. LIMIT number;

    We have a table "employee" as below:

    1.     employee
    2.  
    3.     id  first_name               salary       country
    4.     .......................................................
    5.     1   John                     10000         Canada
    6.     2   Chris                    20000         California
    7.     3   Max                      30000         London
    8.     4   Jenny                    25000         Canada

    LIMIT Clause Example

    The below statement returns the 2 records of the employee table:

    1. SELECT *
    2. FROM employee
    3. LIMIT 2;

    Result

    1.     id  first_name               salary       country
    2.     .......................................................
    3.     1   John                     10000         Canada
    4.     2   Chris                    20000         California

    Hope this will help you :)

    mysql database limit select few records
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: