select top 10 ,(select count() from (select * from (
select d.cardid,a.CompID,b.OrderType,b.RevokeState,b.IsResting,d.IsDelete,b.CreateTime,a.GoodsCode,a.number from
OrderDetail a left join OrderLog b on a.OrderCode=b.BillCode and a.CompID=b.CompID left join MemCard d on b.MemID=d.Id left join goods good on good.id=a.GoodsID and good.CompID=a.CompID)t
where CompID = 11187 AND OrderType = 2 AND RevokeState = 0 AND IsResting = 1 AND IsDelete = 0 AND CreateTime>='20160916053625' AND CreateTime<='20160923053625' and goodscode in (GoodsOrderHZ.GoodsCode)
)a where cardid='0000') as Fit,
(select count(*) from (
select * from (
select d.cardid,a.CompID,b.OrderType,b.RevokeState,b.IsResting,d.IsDelete,b.CreateTime,a.GoodsCode,a.number from
OrderDetail a left join OrderLog b on a.OrderCode=b.BillCode and a.CompID=b.CompID left join MemCard d on b.MemID=d.Id left join goods good on good.id=a.GoodsID and good.CompID=a.CompID)t
where CompID = 11187 AND OrderType = 2 AND RevokeState = 0 AND IsResting = 1 AND IsDelete = 0 AND CreateTime>='20160916053625' AND CreateTime<='20160923053625' and goodscode in (GoodsOrderHZ.GoodsCode)
) a where cardid<>'0000') as Members,
'' as AvgProfit from
(select * from (select GoodsID,MAX(GoodsName)GoodsName,MAX(GoodsCode)GoodsCode,SUM(Number) TotalNum ,SUM(TotalMoney)as TotalMoney,sum(profit) profit from
(select a.GoodsID,a.GoodsName,a.CompID,a.GoodsCode,a.Number,a.TotalMoney,a.profit,b.OrderType,b.RevokeState,b.IsResting,b.BillCode,b.CreateTime,b.Remark,d.CardID,d.IsDelete,d.CardName,good.price as GoodPrice from
OrderDetail a left join OrderLog b on a.OrderCode=b.BillCode and a.CompID=b.CompID left join MemCard d on b.MemID=d.Id left join goods good on good.id=a.GoodsID and good.CompID=a.CompID)o
where CompID = 11187 AND OrderType = 2 AND RevokeState = 0 AND IsResting = 1 AND IsDelete = 0 AND CreateTime>'20160916053625' AND CreateTime<='20160923053625 '
group by GoodsID )x left join (select GoodsID as GoodsStockID,SUM(StockNum)as tstocknum from GoodsStock where CompID=11187 AND ShopID in (select id from Shop where compid=11187)
group by GoodsID)y on x.GoodsID=y.GoodsStockID)as GoodsOrderHZ order by totalnum desc
sql语句变成mysql...............................
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
1条回答 默认 最新
悬赏问题
- ¥15 基于卷积神经网络的声纹识别
- ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
- ¥100 为什么这个恒流源电路不能恒流?
- ¥15 有偿求跨组件数据流路径图
- ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
- ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
- ¥15 CSAPPattacklab
- ¥15 一直显示正在等待HID—ISP
- ¥15 Python turtle 画图
- ¥15 stm32开发clion时遇到的编译问题