SELECT name, employeeID FROM employee WHERE salary>(SELECT AVG(salary) From employee WHERE departID=10);
SELECT a.name,a.employeeID FROM employee AS a WHERE a.salary> (SELECT AVG(salary) from employee where departID=10);
这道题你会答吗?花几分钟告诉大家答案吧!
扫描二维码,关注牛客网
下载牛客APP,随时随地刷题