create table stuff(ID int default autoincrement, remark char(100), primary key (ID));insert into stuff(remark) values('aa');insert into stuff(remark) values('cc');insert into stuff(remark) values('ff');insert into stuff(remark) values('dd');insert into stuff(remark) values('bb');insert into stuff(remark) values('ee');select LIST(remark order by ID) from stuff;-- will return: 'aa,cc,ff,dd,bb,ee' as a single string valueselect LIST(remark order by remark) from stuff;-- will return: 'aa,bb,cc,dd,ee,ff' as a single string value
SELECT LIST(DISTINCTtrans_no || '+"'|| remark ||'"+"', '' ORDER BY trans_no)FROM#temp_1
_______________
返回组中每行值的分隔列表。
语法
参数
返回值
注释
标准和兼容性
另请参见
示例
excel实现list的功能