Skip to main content
Practice

Comparison Operators

Comparison operators filter data by comparing values in a table.

You use them in the WHERE clause to return only rows that match certain conditions.


Quick Example​

This query shows only students with grades 90 or above.

Show students with high grades
SELECT name, grade
FROM students
WHERE grade >= 90;

Learn More​

Go through the slide deck on a right to see examples of comparison operators like =, !=, >, <, and BETWEEN, and how they're used in real queries.

Want to learn more?

Join CodeFriends Plus membership or enroll in a course to start your journey.