SQL Comparison Operators

Comparison operators help you compare values in the WHERE clause to filter data.

🔹 Common Comparison Operators

Operator	Meaning	Example
`=`	Equal to	`WHERE salary = 50000`
`<>` or `!=`	Not equal to	`WHERE department <> 'HR'`
`>`	Greater than	`WHERE salary > 60000`
`<`	Less than	`WHERE age < 30`
`>=`	Greater than or equal to	`WHERE experience >= 5`
`<=`	Less than or equal to	`WHERE age <= 40`

🔹 Usage Example

SELECT * FROM employees WHERE salary >= 50000 AND department <> 'Sales';

🧠 Quick Recap

Use = and <> (or !=) for equality and inequality
Use <, >, <=, >= for range checks
Essential for filtering rows in your queries

✅ Master these to control exactly which rows you get!