Ordering the Results

SELECT name, stock price

FROM Company

WHERE country=“USA” AND stockPrice > 50

ORDERBY country, name

Ordering is ascending, unless you specify the DESC keyword.

Ties are broken by the second attribute on the ORDERBY list, etc.

Previous slide

Next slide

Back to first slide

View graphic version