where and order by in sql code example

Example 1: order by with more than one column

The following shows that you can perform order by with more
than one column.
'ASC' denotes ascending sort order, but is optional as it is the default sort order.
'DESC' denotes descending sort order

SELECT Id, CompanyName, City, Country  
FROM Supplier 
WHERE Country IN ('USA', 'Japan', 'Germany') 
ORDER BY Country ASC, CompanyName DESC

Example 2: sort order on two columns sql

Sort by multiple column : ORDER BY column1 DESC, column2

Example 3: sql order

SQL order of execution defines the
execution order of clauses.

-Select
It starts execution with 
-from  (Choose and join tables to get base data)
after from
-where ( filters base data )
-group by (Aggregates base data)
-having (filters aggregated data)
-select (returns final data)
-order by (sorts the final data)
-limit (limits the returned data to a row count)

Only select and from are mandatory