单选题
发布日期:2020-04-10
SELECT a.last_name, a.salary, a.department_id,
maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;
SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))
SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);
SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);
题王网让考试变得更简单
扫码关注题王,更多免费功能准备上线!
此试题出现在
其他考试
为什么要保护文化遗产?
“昔日同窗情,至今常怀念”,这属于( )。
ACD保存液中枸橼酸盐的抗凝作用,是结合血液中的()
胶州秧歌的体态特征为以下哪个?()
保险代理人的代理行为是由()和民法调整的行为。
一个国家的生产剩余通常以两种方式出现一是政府的税收二是居民的储蓄。
《中华人民共和国安全生产法》由中华人民共和国第九届全国人民代表常务委员会第二十八次会议于2002年()通过公布,自2002年()起施行。
肝硬化雌、雄激素比例失衡会出现( )。
以下疾病可引起无排卵性不孕,除了( )。
阿米巴痢疾典型的溃疡形态是________。
暂无相关推荐~
Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables: Which MERGE sta...
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: Evaluate this SQL...
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. EMPLO...
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NA...
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn n...
Examine the structure of the EMPLOYEES table: You issue these statements: At the...
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIR...
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIR...
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn n...
Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPL...