(单选题)2: Given the following table:
CREATE TABLE employee
(name CHAR(10), salary DEC NOT NULL WITH DEFAULT)
INSERT INTO employee (name, salary) VALUES ('SMITH', 30000)
INSERT INTO employee (name) VALUES ('JONES')
INSERT INTO employee (name, salary) VALUES ('ALI', 35000)
Which of the following statements will retrieve more than one row?
A: SELECT salary FROM employee WHERE salary IN (SELECT (salary/(SELECT
SUM(salary) FROM employee)) FROM employee)
B: SELECT COALESCE(AVG(salary)) FROM employee
C: SELECT SUM(salary)/COUNT(*) FROM employee
D: SELECT salary/(SELECT SUM(salary) FROM employee) FROM employee
(责任编辑:admin)要这答案加QQ:800020900 或加微信:vq800020900 获取