Skip
Arish's avatar

128. Filter with Arithmetic

Arithmetic in WHERE

sql
1SELECT * FROM students WHERE marks % 10 = 0;

Find students with marks divisible by 10.

Even Values

sql
1SELECT * FROM students WHERE marks % 2 = 0;