员工信息表:
编号,手机,职务
A1,13609081861,PM
A2,13609081234,AM
A3,13609123456,GM
A6,12345678990,CIO
A7,12341343542,CTO
A8,12324532334,FIO
报销信息表:
员工编号,报销金额,备注(允许为NULL)
A1,1800
A2,800
A3,800
A3,1500
A3,600
A6 3000
A7,1800
员工信息表:
编号,手机,职务
A1,13609081861,PM
A2,13609081234,AM
A3,13609123456,GM
A6,12345678990,CIO
A7,12341343542,CTO
A8,12324532334,FIO
报销信息表:
员工编号,报销金额,备注(允许为NULL)
A1,1800
A2,800
A3,800
A3,1500
A3,600
A6 3000
A7,1800
select max(t.count) ,t.* from (select count(a.员工编号) count,a.员工编号,b.手机,b.职务 from 报销信息表 a left join 员工信息表 b on a.员工编号=b.员工编号 group by a.员工编号,b.手机,b.职务) t;