What does the SQL query 'SELECT * FROM employees WHERE salary > 100000;' do?

• A. Returns all employees
• B. Returns all employees with salary greater than 100000
• C. Deletes employees with salary greater than 100000
• D. Returns employees with salary less than 100000

Answer: (B)

This query demonstrates how to filter data with a condition. It uses SELECT * to return all columns for rows, but only for employees that meet the condition in the WHERE clause. The condition salary > 100000 means the salary value must be strictly greater than 100,000. So the result is every employee record where the salary exceeds 100k, with all of that employee’s fields shown. It does not delete data, and it does not include employees whose salary is 100,000 or less. If a salary is stored as a non-numeric type, you might need casting; NULL salaries won’t satisfy the condition and won’t appear in the result. If no rows meet the condition, you get an empty result set.