Modulo Filtering
sql
1-- Marks divisible by 5
2SELECT * FROM students WHERE marks % 5 = 0;
3
4-- Every 3rd student
5SELECT * FROM students WHERE id % 3 = 0;
1-- Marks divisible by 5
2SELECT * FROM students WHERE marks % 5 = 0;
3
4-- Every 3rd student
5SELECT * FROM students WHERE id % 3 = 0;