CS250 > SQL / RA > Flashcards
Selection
WHERE
σ (sigma)
Projection
SELECT attribute list
π (pi)
Difference
none
RA “−”
JOIN
at least one
⋈
DIVISION
all
÷
WHERE vs HAVING
Before vs After the crowdWHERE filters rows.HAVING filters groups.