暂无图片
返回数说广场
小草
暂无图片
2025-05-22 半个DBA
在 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
分享

评论

热门数说