SELECT WM_CONCAT(MYTABLE.DATA) -- 1,2,3,4,5 FROM MYTABLE GROUP BY MYTABLE.CATETORY -- A, B,C 是这意思?
多对多的关系么 建3个表,表1存放A,B,C;表2存放子类1,2,3,4,5;表3存放对应关系
楼主描述信息不清楚啊,你是想要表结构,还是SQL语句?
sql 语句 实现 A 对应 1 2 3 B 对应 4 5 C 对应 1 2 3 4 5
select 'A','123' from dual union all select 'B','45' from dual union all select 'C','12345' from dual ?
select substr('12345',level,1) as subst from DUAL connect by substr('12345',level,1) is not null?
原数据是怎样的? eg:... 想要的结果是怎样的? eg:...真心没看明白。
不好意思没描述清楚,主要是实现用户对应相应的类,'YJZ','YJSJZ'‘WLZ’'YWZ'这些是用户 A B C 是几个类,下面是我自己写的但是还有个问题是,现在还有个用户(crh)对应着是 A,B,C.用下面写法该怎么写,或者提供其他写法 case when (SELECT USR_GROUP FROM USERS) in ('YJZ','YJSJZ') THEN 'A' when (SELECT USR_GROUP FROM USERS ) in ('WLZ') THEN 'C' when (SELECT USR_GROUP FROM USERS) in ('XTBZ','YWZ') THEN 'B' ELSE '' END )
SELECT WM_CONCAT(MYTABLE.DATA) -- 1,2,3,4,5
FROM MYTABLE
GROUP BY MYTABLE.CATETORY -- A, B,C
是这意思?
建3个表,表1存放A,B,C;表2存放子类1,2,3,4,5;表3存放对应关系
B 对应 4 5
C 对应 1 2 3 4 5
union all
select 'B','45' from dual
union all
select 'C','12345' from dual
?
想要的结果是怎样的? eg:...真心没看明白。
case
when (SELECT USR_GROUP FROM USERS) in ('YJZ','YJSJZ') THEN 'A'
when (SELECT USR_GROUP FROM USERS ) in ('WLZ') THEN 'C'
when (SELECT USR_GROUP FROM USERS) in ('XTBZ','YWZ') THEN 'B'
ELSE '' END )