Which of the following has been achieved by the following SQL codes? SELECT employee_id FROM employees WHERE commission_pct = .5 OR salary > 23000;

A. it returns employees who have a 50% of a salary greater than $23,000:
B. it returns employees who have a 50% commission rate or a salary greater than $23,000:
C. runtime error
D. it returns employees who have a 50% of a salary less than $23,000:
E. invalid syntax
F. it returns employees who have a 50% commission rate and a salary greater than $23,000:

Ans:B

No comments:

Post a Comment

The advantages of Outsourcing Web Development Services

In the present digital world, acquiring a solid web presence is essential for companies to flourish. A well designed site is much much more ...