Comparison Operators
Comparison operators help you filter data by comparing values in a table.
They're used in the WHERE clause to find rows that meet specific conditions.
Quick Example
Show students with high grades
SELECT name, grade FROM students WHERE grade >= 90;
This query shows only students with grades 90 or above.
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.
Quiz
0 / 1
What does the following query return?
SELECT name FROM students WHERE grade != 100;
Students with grade exactly 100
Students with any grade except 100
Only students who failed
No students (it’s a wrong query)
Lecture
AI Tutor
Design
Upload
Notes
Favorites
Help