一、
select rs.* from (SELECT * from common_role_menu ORDER BY create_time desc) rs GROUP BY rs.role_id(待验证)
二、
select a.* from common_role_menu a where a.create_time = (select max(create_time) from common_role_menu where a.role_id = role_id)
一、
select rs.* from (SELECT * from common_role_menu ORDER BY create_time desc) rs GROUP BY rs.role_id(待验证)
二、
select a.* from common_role_menu a where a.create_time = (select max(create_time) from common_role_menu where a.role_id = role_id)