Some Numeric Queries are

• • • / ≥ ≤ > <

We all know how to use these. right?

Example:

SELECT * FROM employees WHERE salary > 50000;

I am not giving more examples.

AND: This operator is used to filter records based on more than one condition

SELECT * FROM products WHERE price BETWEEN 100 AND 500;

OR: This operator is used to filter records based on more than one condition

SELECT * FROM employees WHERE department = 'Sales' OR salary > 60000;