Ordering the Results

SELECT name, stock price

FROM Company

WHERE country=‘USA’ AND stockPrice > 50

ORDER BY country, name

Ordering is ascending, unless you specify the DESC keyword.

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

Previous slide

Next slide

Back to first slide

View graphic version