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

  • SELECT TOP Clause in MySQL

    @neha.bhatt
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 798
    Comment on it

    The SELECT TOP clause is used to return specific number of records with thousands of records. It is used to select top N number of records from a table. We can use number or percent to select record.

    TOP clause is not supported by all the databases.

    For e.g- MySQL uses LIMIT

                Oracle uses ROWNUM

                MS SQL uses TOP

    1. SELECT TOP:-

    Syntax of SELECT TOP:-

    SELECT TOP number|percent column_name(s)
    FROM table_name WHERE [condition] ;

     

    2.LIMIT:-

    Syntax of LIMIT:-

    SELECT column_name(s)
    FROM table_name
    LIMIT number;

    To display elements in ascending or descending order:-

    SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
LIMIT number_rows [ OFFSET offset_value ];

     

    3. ROWNUM:-

    Syntax of ROWNUM:-

    SELECT column_name(s)
    FROM table_name
    WHERE ROWNUM <= number;

    In place of number we will give the number of rows we want to be selected.

    SQL Select TOP MySQL limit
    Comment on it

 0 Comment(s)

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

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: