forked from angelo/java-retail-app
9 lines
160 B
MySQL
9 lines
160 B
MySQL
|
-- 校验后台菜单权限是否唯一
|
||
|
|
select t.perms
|
||
|
|
from SYS_MENU t
|
||
|
|
where t.del_flag = 0
|
||
|
|
and t.menu_type = 'C'
|
||
|
|
group by t.perms
|
||
|
|
having count(t.perms) > 1
|
||
|
|
|