返回数说广场 #每日打卡#
0
在 Oracle 数据库中,想要查询员工表(EMPLOYEES)中工资(SALARY)高于平均工资的员工信息,以下正确的 SQL 语句是A
A
SELECT * FROM EMPLOYEES WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);
B
SELECT * FROM EMPLOYEES, (SELECT AVG(SALARY) FROM EMPLOYEES) AS AVG_SALARY WHERE SALARY > AVG_SALARY;
C
SELECT * FROM EMPLOYEES HAVING SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);
D
SELECT * FROM EMPLOYEES WHERE SALARY > AVG(SALARY);
0
0 259
分享
评论
热门数说



