questions - Question: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?

a.        It returns employees who have 50% of the salary greater than $23,000:
b.        It returns employees who have 50% commission rate or salary greater than $23,000:
c.        It returns employees who have 50% of salary less than $23,000:
d.        None of the above

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.