Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • ORDER BY keyword in SQL

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 235
    Comment on it

    We use ORDER BY to make our record list in a ordered manner in the sense of descending /ascending sort.


    Syntax:-

    SELECT column_name, column_name FROM table_name ORDER BY column_name ASC|DESC


    Note:- User can ORDER BY more then one column in a single query like:-

    SELECT column_name, column_name FROM table_name ORDER BY column_name1 ASC|DESC,column_name2 ASC|DESC;

 0 Comment(s)

Sign In
                           OR                           
                           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: