在sql server中的合并語(yǔ)句可以用xml path

詳見(jiàn)http://www.cnblogs.com/codeyu/archive/2010/05/25/1743474.html

而oracle的合并可以用 listagg配合within group

select * from (
select groupvalue,max(sendtime) as sendtime,
listagg(content) within group (order by sort) as content from messages a
group by groupvalue
) order by sendtime desc

?

還可以用這一句

select wm_concat(content) from messages

合并短信的內(nèi)容

?

oracle合并語(yǔ)句