EasyWHERE & Filtering
Find employees with salary greater than 60000
The query
SQL
SELECT first_name, last_name, salary, job_title
FROM employees
WHERE salary > 60000
ORDER BY salary DESC;Note
“Basic comparison operators: >, <, >=, <=, =, != (or <>)
SELECT first_name, last_name, salary, job_title
FROM employees
WHERE salary > 60000
ORDER BY salary DESC;Note
“Basic comparison operators: >, <, >=, <=, =, != (or <>)