此資料直接從下方網址複製過來，方便以後該網站如果壞掉後還可以參考:
1.
RowID column_to_return_as_string
2.
--------- --------------------------
3.
1 Me
4.
2 Myself
5.
3 I
6.
7.
-- to be returned as
8.
RowID my_field_name
9.
--------- --------------------------
10.
1 Me,Myself,I
MySQL
1.
SELECT
2.
(
3.
SELECT
4.
GROUP_CONCAT(column_to_return_as_string)
5.
FROM
6.
a_pretend_table
7.
WHERE
8.
a_condition=true
9.
) AS my_field_name
10.
FROM
11.
another_pretend_table
T-SQL
1.
SELECT
2.
STUFF(
3.
(
4.
SELECT
5.
',' + column_to_return_as_string
6.
FROM
7.
a_pretend_table
8.
WHERE
9.
a_condition=true
10.
FOR XML PATH ('')
11.
),1,1,''
12.
) AS my_field_name
13.
FROM
14.
another_pretend_table
Oracle
1.
SELECT
2.
(
3.
SELECT
4.
wmsys.wm_concat(column_to_return_as_string)
5.
FROM
6.
a_pretend_table
7.
WHERE
8.
a_condition=true
9.
) AS my_field_name
10.
FROM
11.
another_pretend_table
沒有留言:
張貼留言