具体是这样的: select distinct PermissionString from roleadmin where roleid in (1,3)
查找到的结果:
PermissionString字段(字符串类型)
2,7
3,7
执行后我查找到这样的两条结果,但是这不是我想要的,我想要查找到这两天记录中的7,如何写
谢谢!
查找到的结果:
PermissionString字段(字符串类型)
2,7
3,7
执行后我查找到这样的两条结果,但是这不是我想要的,我想要查找到这两天记录中的7,如何写
谢谢!
from roleadmin where roleid in (1,3)
distinct stuff(PermissionString,1,charindex(',',PermissionString),'') as
PermissionString
from
roleadmin
where
roleid in (1,3)
from roleadmin
where roleid in (1,3)
group by PermissionString
having count(distinct roleid)=2