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]
设定mysql查询编码 利用mysql查询每个部门工资最高的两个人 – 数据库 – 前端 vb mysql数据库查询
如果觉得《设定mysql查询编码 利用mysql查询每个部门工资最高的两个人 – 数据库 – 前端 》对你有帮助,请点赞、收藏,并留下你的观点哦!