If you needed the database to select values in a specific order but order them in ascending order, which of the following clauses should you use along with the SELECT command? Select one. code example

Example: 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

Tags:

Sql Example