ORDER BY Clause Sorting Explained in SQL

ORDER BY Clause Sorting Explained in SQL

Order by clause, in SQL, is used for sorting of data either in ascending order or descending order. This sorting base on one or more columns existing within the table. In some DBMS, sorting in ascending order is a default feature.

Syntax:

SELECT col_name_1, col_name_2, … , col_name_n
FROM tbl_name
ORDER BY col_name ASC|DESC, col_name ASC|DESC, … , col_name_N ASC|DESC;

In this syntax, Order by clause is followed by the column name, followed by the order type, either ascending or descending. Order by clause can be used with multiple columns.

For Example:

The current table view of the Customers table is as follows:

            SELECT * FROM Customers

            Order by C_Name

Following is the output of the above query.

In the above table, all the data is sorted in ascending order. The default execution of Order by clause is in ascending order therefore it is not mandatory to mentioned ASC, however, if sorting is required in descending order than it is mandatory to use the keyword DESC after the column.

For Example:

            SELECT * FROM Customers

            Order by C_Name DESC

Following is the output of the above query.

More Related Articles For You

• Architecture of DBMS
• CODDS RULE DBMS
• Database Models in DBMS
• Relational DBMS Concepts
• Keys and Types of keys in Database
• Database Normalization
• Generalization, Specialization and Aggregation Concepts in DBMS
• ERD Diagram Tutorial with Examples in DBMS
• Introduction to SQL
• How to Create Query in SQL, Create Table, Delete Table and User Insert Info Statements
• Alter Query Command in SQL, Add, Modify and Drop Column in Table
• TCL Commands in SQL
• Truncate Query, Drop and Rename Query in SQL
• All DML Statement in SQL, Select Statement, Delete, Insert and Update Statement
• Data Control Language DCL Revoke and Grant Command in SQL
• Select Statement or Select Query in SQL Explained with Examples
• Distinct Keyword Explained in SQL
• WHERE Statement or WHERE Clause in SQL Statement Explained
• AND & OR Operators in SQL
• LIKE Operator in SQL
• Group By Clause in SQL
• Having Clause Explained in SQL
• SQL Constraints
• SQL Aggregate Functions
• SQL Aliases Use and Purpose in SQL
• SQL Joins Types, Use and Purpose
• SQL Sequence Syntax and Use with Examples
• SQL View
• SET Operation in SQL, UNION, UNION ALL, Intersect and Minus

    DBMS Tutorial

    SQL and DBMS Interview Questions with Answers

    DBMS and SQL Practice Tests , Questions and Quizzes