What does WHERE do?
sql
SELECT name FROM Student WHERE marks > 80;
The table has 100 rows and 30 of them have marks above 80.
What comes back?
sql
SELECT name FROM Student WHERE marks > 80;
The table has 100 rows and 30 of them have marks above 80.
What comes back?