sql 多条数据合并一条

[javamode]

select * from a
结果显示
a b c d e f
1 2 3 4 5 6
7 8 9 10 11 12
从a表 怎么查显示 123456789……
用sql怎么写

[ACMAIN_CHM]

select replace(wm_concat(a||b||c||d||e||f),',','') from a;

SQL> select * from a;

         A          B          C          D          E          F
---------- ---------- ---------- ---------- ---------- ----------
         1          2          3          4          5          6
         7          8          9         10         11         12

SQL> select replace(wm_concat(a||b||c||d||e||f),',','') from a;

REPLACE(WM_CONCAT(A||B||C||D||E||F),',','')
--------------------------------------------------------------------------------
123456789101112

SQL>

[gxjwqm]

学习

[shenghuiping2001]

[Quote=引用 5 楼 acmain_chm 的回复:]
SQL codeselectreplace(wm_concat(a||b||c||d||e||f),',','')from a;

SQL codeSQL>select*from a;

A B C D E F---------- ---------- ---------- ---------- ---------- ----------123456789101112

SQL>selectreplace(wm_concat(a||b||c||d||e||f),',','')from a;REPLACE(WM_CONCAT(A||B||C||D||E||F),',','')--------------------------------------------------------------------------------123456789101112

SQL>
[/Quote]

真是一个强呀!赞!

[gna15]

select *
from a a1, a b1
where a1.A = (select min(a) from a)
and b1.F = (select max(f) from a)

结果正确，感觉方法有些笨。共同探讨

[ojuju10]

select replace(wm_concat(a||b||c||d||e||f),',','') from tb

[心中的彩虹]

SQL> create table tb
2 (a int,
3 b int,
4 c int,
5 d int,
6 e int,
7 f int
8 )
9 tablespace myts
10 /

表已创建。


SQL> edi
已写入 file afiedt.buf

1* insert into tb values(1,2,3,4,5,6)
SQL> /

已创建 1 行。

SQL> insert into tb values(7,8,9,10,11,12);

已创建 1 行。
正式语句

SQL> select wmsys.wm_concat(a||b||c||d||e||f) from tb;

WMSYS.WM_CONCAT(A||B||C||D||E||F)
--------------------------------------------------------------------------------
123456,789101112

因为单独用WMSYS.WM_CONCAT 中间有逗号,所以要下面这样解：
SQL> select replace(wmsys.wm_concat(a||b||c||d||e||f),',','') from tb;

REPLACE(WMSYS.WM_CONCAT(A||B||C||D||E||F),',','')
--------------------------------------------------------------------------------
123456789101112

[crazylaa]

select replace(wmsys.wm_concat(a||b||c||d||e||f),',','') from tb order by a;

[碧水幽幽泉]

select replace(wm_concat(a||b||c||d||e||f),',') from a

[fatfoxz]

要求很高啊。。。

[小灰狼W]

select replace(wm_concat(a||b||c||d||e||f),',') from a

[hebo2005]

[Quote=引用 2 楼 wildwave 的回复:]
select replace(wm_concat(a||b||c||d||e||f),',') from a
[/Quote]
可能会顺序错乱的

[iqlife]

先行合并,在拼接列

[wyx100]

select replace(wmsys.wm_concat(a||b||c||d||e||f),',','') from tb order by a;

[zchcs]

[Quote=引用 5 楼 acmain_chm 的回复:]
SQL codeselectreplace(wm_concat(a||b||c||d||e||f),',','')from a;

SQL codeSQL>select*from a;

A B C D E F---------- ---------- ---------- ---------- ---------- ----------123456789101112

SQL>selectreplace(wm_concat(a||b||c||d||e||f),',','')from a;REPLACE(WM_CONCAT(A||B||C||D||E||F),',','')--------------------------------------------------------------------------------123456789101112

SQL>
[/Quote]

同意