select t.role, count(*) from user t group by t.role
to LinZhongBao() : 注意user表里的rule是个varchar2,可能包含多个值
INSERT INTO t_Test SELECT * FROM ( SELECT f_NodeID,f_ParentID FROM t_Test WHERE f_NodeID !=1 START WITH f_NodeID = 1 CONNECT BY f_ParentID = PRIOR f_NodeID UNION ALL SELECT f_NodeID , 10 --bB节点ID FROM t_Test WHERE f_NodeID = 1 )
必须先将逗号分割的字符串变成对应的记录, 再进行group by..
试试下面的语句把 select count(userid) from user,role where instr(user.role,role.rolename)>0
select role.rolename,count(userid) from user,role where instr(user.role,role.rolename)>0 group by role.rolename
sbaz(万神渡劫) 可解,有没有更好的办法了?
select * from role a , user b where a.role like '%'||b.rolename||'%'
from user t
group by t.role
注意user表里的rule是个varchar2,可能包含多个值
SELECT *
FROM
(
SELECT f_NodeID,f_ParentID FROM t_Test
WHERE f_NodeID !=1
START WITH f_NodeID = 1
CONNECT BY f_ParentID = PRIOR f_NodeID
UNION ALL
SELECT
f_NodeID ,
10 --bB节点ID
FROM t_Test
WHERE f_NodeID = 1
)
select count(userid) from user,role
where instr(user.role,role.rolename)>0
where instr(user.role,role.rolename)>0
group by role.rolename
select *
from role a , user b
where a.role like '%'||b.rolename||'%'