SQL練習(xí)八
有一個(gè)全部員工的薪水表salaries簡(jiǎn)況如下:
有一個(gè)各個(gè)部門(mén)的領(lǐng)導(dǎo)表dept_manager簡(jiǎn)況如下:
請(qǐng)你查找各個(gè)部門(mén)當(dāng)前領(lǐng)導(dǎo)的薪水詳情以及其對(duì)應(yīng)部門(mén)編號(hào)dept_no，輸出結(jié)果以salaries.emp_no升序排序，并且請(qǐng)注意輸出結(jié)果里面dept_no列是最后一列，以上例子輸出如下:
表結(jié)構(gòu)
drop table if exists `salaries` ;drop table if exists `dept_manager` ;CREATE TABLE `salaries` (`emp_no` int(11) NOT NULL,`salary` int(11) NOT NULL,`from_date` date NOT NULL,`to_date` date NOT NULL,PRIMARY KEY (`emp_no`,`from_date`));CREATE TABLE `dept_manager` (`dept_no` char(4) NOT NULL,`emp_no` int(11) NOT NULL,`to_date` date NOT NULL,PRIMARY KEY (`emp_no`,`dept_no`));
SQL語(yǔ)句
INSERT INTO dept_manager VALUES('d001',10002,'9999-01-01');INSERT INTO dept_manager VALUES('d002',10006,'9999-01-01');INSERT INTO dept_manager VALUES('d003',10005,'9999-01-01');INSERT INTO dept_manager VALUES('d004',10004,'9999-01-01');INSERT INTO salaries VALUES(10001,88958,'2002-06-22','9999-01-01');INSERT INTO salaries VALUES(10002,72527,'2001-08-02','9999-01-01');INSERT INTO salaries VALUES(10003,43311,'2001-12-01','9999-01-01');INSERT INTO salaries VALUES(10004,74057,'2001-11-27','9999-01-01');INSERT INTO salaries VALUES(10005,94692,'2001-09-09','9999-01-01');INSERT INTO salaries VALUES(10006,43311,'2001-08-02','9999-01-01');INSERT INTO salaries VALUES(10007,88070,'2002-02-07','9999-01-01');
答案：
SQL練習(xí)九分享答案評(píng)論
圖片
表情