sql复杂的子查询，横向合并结果集
2017-07-29 13:59:30

第一个查询的结果集select * from(select c.msName,a.msId,c.msPrice, c.msPrice*COUNT(a.msId) as totalMoney,sum(a.msAmount) as totalCount from BillConsume a right join (select top 1 msTime as startTime,GETDATE() as endTime from BillConsume where DateDiff(dd,msTime,getdate())=0 order by msTi ......

本文摘自 ：https://www.cnblogs.com/