Ravindra BagaleCourses & study guides Track your progress

WHERE: Keep Only the Rows You Need — Ravi Sir's Cards

All SQL cards

Revision cards

WHERE filters rows. If you include the wrong rows, your totals will be wrong.
WHERE filters rows · PNG

Interview cards

What does WHERE do? WHERE filters rows. Only the rows that match the condition are kept for sorting and totals.
What does WHERE do? · PNG

Comparison cards

AND vs OR. AND keeps a row only when every condition is true. OR keeps a row when at least one condition is true.
AND vs OR · PNG