查询每个部门工资最高的员工

CREATE TABLE `employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id唯一标识 /注：自增',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `salary` int(11) DEFAULT NULL COMMENT '薪水',
  `departmentId` varchar(50) DEFAULT NULL COMMENT 'ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='员工表';
CREATE TABLE `department` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id唯一标识 /注：自增',
  `name` varchar(50) DEFAULT NULL COMMENT '部门名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='部门表';

insert into employee (id,name,salary,departmentId) value (1,'Joe',70000,'1');
insert into employee (id,name,salary,departmentId) value (2,'Henry',80000,'2');
insert into employee (id,name,salary,departmentId) value (3,'sam',60000,'2');
in