mysql 查詢生成編號(hào)，利用mysql查詢每個(gè)部門工資最高的兩個(gè)人？
下面只定義了基本結(jié)構(gòu)，其他的如索引，字符集等要酌情加上。
create table departments (
id int primary key,
name varchar(50) not null,
parent_id int
)
create table employee (
id int primary key,
department_id int not null,
name varchar(50) not null,
)
下面是一些偽代碼
department = select * from departments where name = [department_name]
departments = select * from departments where parent_id = department.id
select * from employee where department_id in [departments.id + department.id]