Skip
Arish's avatar

109. Practice - Filter by Length

Exercise: Double Digit Marks

Find students with marks having 2 digits (10-99).

Solution

sql
1SELECT * FROM students
2WHERE LENGTH(marks) = 2;

Or more precisely:

sql
1SELECT * FROM students
2WHERE marks >= 10 AND marks <= 99;