id name
1 a
2 就
3 是
4 嗯
5 cc
6 dd拼接结果为:
a,就,是,嗯,cc,dd
用逗号拼接起来
1 a
2 就
3 是
4 嗯
5 cc
6 dd拼接结果为:
a,就,是,嗯,cc,dd
用逗号拼接起来
解决方案 »
- 数据库搜索字段问题
- oracle-exp导出数据不完整
- 用sql语句实现查询出所有的每一门功课都大于75分的学生的信息?急
- ORACLE数据库的数据恢复问题,请高手指教!!
- 关键字
- oralce 一对多
- windows2000下怎么建立odbc数据源 for oracle
- OracleOraHome8iManagementServer Service启动失败,Why?
- 没有oracle服务端复制文件的权限,Linux的oracle客户端如何获取并使用sqlldr?
- plsql登录不了,一直是ora-12154是什么原因
- 有关IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
- lsnrctl stop 监听启动和停止都报错,数据库能正常打开 oracle11g linux
with t as (
select 1 as ismaster,'qingyun' as uname,'租赁' as state from dual union all
select 0 as ismaster,'aa' as uname,'租赁' as staet from dual union all
select 0 as ismaster,'aa' as uname,'空闲' as staet from dual
)
select wmsys.wm_concat(uname) from (select * from t where state='租赁' order by ismaster desc)
SELECT 1 id,'a' NAME FROM dual
UNION ALL
SELECT 2,'就' FROM dual
UNION ALL
SELECT 2,'是' FROM dual
UNION ALL
SELECT 2,'嗯' FROM dual
UNION ALL
SELECT 2,'cc' FROM dual
UNION ALL
SELECT 2,'dd' FROM dual)
SELECT wm_concat(name) FROM t