Selections

SELECT *

FROM Company

WHERE country=“USA” AND stockPrice > 50

You can use:

attribute names of the relation(s) used in the FROM.

comparison operators: =, <>, <, >, <=, >=

apply arithmetic operations: stockprice*2

operations on strings (e.g., “||” for concatenation).

Lexicographic order on strings.

Pattern matching: s LIKE p

Special stuff for comparing dates and times.

Previous slide

Next slide

Back to first slide

View graphic version