SQL Advanced

SQL ORDER BY

SQL INSERT INTO STATEMENT

The ORDER BY keyword is used to sort the result.

“CORRIER DETAILS” TABLE NAME

Example

To display the company names in alphabetical order:

RESULT

Example

To display the company names in alphabetical order and the POD Number in numerical order:

SYNTAX

RESULT

Example

To display the company names in reverse alphabetical order:

SYNTAX

RESULT

Example

To display the company names in reverse alphabetical order AND the POD Number in numerical order:

RESULT