Question

SQL 语句 根据最小值查询用户id

如图，dept_id代表部门id，根据role表字段的查询每个部门checkper最小值对应的user_id，求dalao帮助下

Answer 1

select userID from user a left outer join(select min(checkper) as checkper,role_id,dept_id from role group by dept_id,role_id) b on a.role_id=b.rold_id and a.dept_id=b.deptid

Answer 2

SELECT tr.checkper,tu.user_id,tr.dept_id
  FROM Tuser tu
  RIGHT JOIN role tr ON tr.rloe_id=tu.role_id
WHERE checkper=(SELECT MIN(checkper) FROM role)