oracle合并语句
摘要：
在sql server中的合并语句可以用xml path详见http://www.cnblogs.com/codeyu/archive/2010/05/25/1743474.html而oracle的合并可以用 listagg配合within groupselect * from (select groupvalue,max(sendtime) as sendtime,listagg(content) within group (order by sort) as content from messages agroup by groupvalue) order by sendtime desc 阅读全文
posted @ 2014-03-27 16:50 技术先锋 阅读(327) 评论(0) 推荐(0) 编辑
