EasyBasic SELECT
Find employees with salary NULL
The query
SQL
SELECT emp_id, first_name, last_name, job_title
FROM employees
WHERE salary IS NULL;Note
“IS NULL finds rows where salary was never set. Use COALESCE to replace NULLs in display.
SELECT emp_id, first_name, last_name, job_title
FROM employees
WHERE salary IS NULL;Note
“IS NULL finds rows where salary was never set. Use COALESCE to replace NULLs in display.