- 要求:编写一个SQL,获取部门工资前三高的员工信息
- 员工表和部门表结构:
CREATE TABLE `employee` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255),
`salary` decimal(10,2),
`department_id` int(11),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE `department` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- 员工表和部门表数据:
INSERT INTO `employee`(`id`, `name`, `salary`, `department_id`) VALUES (