Projections and Ordering Results

SELECT name AS company, stockprice AS price

FROM Company

WHERE country=‘USA’ AND stockPrice > 50

ORDER BY country, name

SELECT name, stock price

FROM Company

WHERE country=‘USA’ AND stockPrice > 50

Select only a subset of the attributes

Rename the attributes in the resulting table

Previous slide

Next slide

Back to first slide

View graphic version