Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statement is correct with regard to this code?

  1. It returns employees who have 50% of the salary greater than $23,000:

  2. It returns employees who have 50% commission rate or salary greater than $23,000:

  3. It returns employees who have 50% of salary less than $23,000:

  4. None of the above


Correct Option: B

Find more quizzes: