数据库中,如何用SQL语句实现将某字段下的所有记录合成一条记录,用逗...答:MS Sqlserver(for xml path的巧用):select 'T1' M, stuff((select ',' + CAST(T1 as varchar) from Table_1 for xml path('')),1,1,'') Nunionselect 'T2' M, stuff((select ',' + CAST(T2 as varchar) from Table_2 for xml path('')),1,1,'') NOracle(自带这样的...
sql 合并2条查询结果的数据答:使用union "SELECT SUM(金额) AS 金额, SUM(付现金) AS 付现金, SUM(刷卡) AS 刷卡, SUM(付积分) AS 付积分 FROM (SELECT 日期, 账单号, 商品名称, 数量, 单位, 单价, 金额, 付现金, 刷卡, 付积分, 操作员 FROM 消费明细 WHERE (ID IN (SELECT MAX(ID) AS Expr1 FROM 消费明细 AS...