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

  • What is the use of ORDER by Keyword in MySQL.

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 395
    Comment on it

    In MySQL, the ORDER by keyword is used to get records from a table in sorted order. The ORDER BY keyword can use one or more columns to sort the result-set.

    We can sort the records in both ascending and descending order.By default, ORDER by keyword sorts records in Ascending order. For descending order we need to use DESC keyword with the ORDER by keyword.

    ORDER BY Syntax

    1. SELECT column_name, column_name
    2. FROM table_name
    3. ORDER by column_name ASC|DESC, column_name ASC|DESC;

    We have a table "employee" as below:

    1.     employee
    2.  
    3.     id  first_name            last_name       country
    4.     .......................................................
    5.     1   John                     Simp         Canada
    6.     2   Chris                    Hely         Canada
    7.     3   Max                      Roy          Korea
    8.     4   Jenny                    Mill         Canada
    9.     5   Jack                     Simpson      London

    ORDER BY Example

    The below statement selects all the employees from the "employee" table sorted by "country column":

    1. SELECT * FROM employee
    2. ORDER by country;

    Result

    1.     id  first_name            last_name       country
    2.     .......................................................
    3.     1   John                     Simp         Canada
    4.     2   Chris                    Hely         Canada
    5.     4   Jenny                    Mill         Canada
    6.     3   Max                      Roy          Korea
    7.     5   Jack                     Simpson      London

    ORDER BY DESC Example

    he below statement selects all the employees from the "employee" table sorted in descending order by "country column":

    1. SELECT * FROM employee
    2. ORDER by country DESC;

    Result

    1.     id  first_name            last_name       country
    2.     .......................................................
    3.     5   Jack                     Simpson      London
    4.     3   Max                      Roy          Korea
    5.     1   John                     Simp         Canada
    6.     2   Chris                    Hely         Canada
    7.     4   Jenny                    Mill         Canada

    Hope this will help you :)

    mysql database Order by get records in sorting order sort the rows
    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: