WHERE construct in SQL is equivalent to following relational algebra operator ?
2026
WHERE construct in SQL is equivalent to following relational algebra operator ?
Answer: B. σ — The WHERE clause in SQL is used to filter rows based on specified conditions. In relational algebra, this filtering operation corresponds to the selection…
- A.
Π
- B.
σ
- C.
×
- D.
⋈
Attempted by 636 students.
Show answer & explanation
Correct answer: B
The WHERE clause in SQL is used to filter rows based on specified conditions. In relational algebra, this filtering operation corresponds to the selection operator (σ), which selects tuples that satisfy a given predicate.
Loading lesson…