Selection

• Produce a subset of the tuples in a relation which satisfy a given condition

• Unary operation… returns set with same attributes, but ‘selects’ rows

• Use and, or, not, >, <… to build condition

• Find all employees with salary more than $40,000:

Previous slide

Next slide

Back to first slide

View graphic version