Relational Algebra - Select Operator (Selection) - <math>\sigma</math>

About

The select operator is a relational operator that select the rows of a relation.

Articles Related

Visualisation

select vs project

Notation

This can be read as:

• Keep rows that satisfy the condition c (ie predicate)
• Delete rows that fail the condition c (ie predicate)

Example

Select the shirts that satisfy the condition color=blue

• Relational Algebra Notation

<MATH> \LARGE \sigma_{(color='Blue')} Shirts </MATH>

• SQL Notation

SELECT * FROM Shirts WHERE color='Blue'