sql将多行查询结果显示在一行用,号隔开

[mamudelingling]

id Mark
1 A01
2 A02
3 A03
4 A04

查询mark行结果为 'A01,A02,A03,A04'

请问sql语句该如何写，最好是一条sql语句

分数不多了，给的少了点！

[百年树人]

declare @s varchar(1000)
select @s=isnull(@s,'')+mark from tb
select @s

[bancxc]

[Quote=引用 1 楼 josy 的回复:]
SQL code
declare @s varchar(1000)
select @s=isnull(@s,'')+mark from tb
select @s
[/Quote].

[华夏小卒]

declare @s varchar(100)
select @s=isnull(@s+',','')+mark from tb 

select @s 

[黄_瓜]

declare @s varchar(1000)
select @s=isnull(@s,'')+mark from tb
select @s

[百年树人]

如果是sql205及以上版本，可以这样

---测试数据---
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([id] int,[Mark] varchar(3))
insert [tb]
select 1,'A01' union all
select 2,'A02' union all
select 3,'A03' union all
select 4,'A04'
 
---查询---
select 
  stuff((select ','+mark from tb for xml path('')),1,1,'')


---结果---

----------------------------
A01,A02,A03,A04

(1 行受影响)

[bancxc]

declare @s varchar(100)
select @s=isnull(','+@s,'')+mark from tb 

select @s 

[mamudelingling]

可惜是sql2000的,用逗号隔开呢？

[superpander]

declare @s varchar(1000)
select @s=isnull(@s,'')+mark+',' from tb
select substring(@s,0,len(@s))