Order By Statement

Front 1

Define Order by statement

Back 1

Used to sort the selected results.

Format:
Select column_name
From table name
Order by column_name

Front 2

How to sort the company name in alphabetical order?

Back 2

Select company_name
From table name
Order by company_name

Front 3

How to sort the company name in reverse alphabetical order?

Back 3

Select company_name
From table name
Order by company_name desc

Front 4

How to sort the company name in alphabetical order and order number in numerical order?

Back 4

A. This one will sort the company name in alphabetical order first and then sort the order number within the same company name in alphabetical order.

Select company_name, order number
From table name
Order by company_name, order number;

B. This one will sort the order number in numerical order (ie ascending order) first and then sort the same company name in alphabetical order

Front 5

How to sort order number in numerical order?

Back 5

Select order number
From table name
Order by order number

(Note: if not specify, it will sort by ascending; to sort by descending, need to put desc at the end of Order by statement)