MAKE FULL WEB APPLICATION WITH JUST SQL KNOWLEDGE? CLICK HERE

Our SQL tutorial will help to teach you how to use commonly used SQL commands and you will be able to apply most of the knowledge gathered from this SQL tutorial to any of the databases above :-

The SQL ORDER BY clause comes in easy to use when you want to sort your SQL result sets by some column(s). You can use a column, which can compare to other similar column number instead of the column name in the ORDER BY clause. ASC is the default sort order.

The Syntax of ORDER BY clause is :-

The syntax for the ORDER BY clause is to obtain and display data in a specific order :-

For Instance,

The ORDER BY clause is used to sort the rows.

Orders :-

EXAMPLE 1:-

To display the companies in alphabetical order:

RESULT:-

EXAMPLE 2:-

To display the companies in alphabetical order AND the order numbers in numerical order:

RESULTS:-

EXAMPLE 3:-

To display the companies in reverse alphabetical order:

RESULT:-

EXAMPLE 4:-

To display the companies in reverse alphabetical order AND the order numbers in numerical order:

RESULT:-

If you don't find what you are looking for. Please click here to submit your query, our experts will reply soon.