Document

---随心买统计查询

---随心买统计查询

--随心买新增-当日人次
select COUNT(*) from(select distinct userID from HUR_Product_Buy where createDate between '2016-07-12 00:00:00' and '2016-07-12 23:59:59') as a
--随心买新增-累计总人次
union all select COUNT(*) from(select distinct userID from HUR_Product_Buy where createDate between '1980-01-01' and '2016-07-12 23:59:59') as b

--随心买新增-当日金额
union all select SUM(amount) from HUR_Product_Buy where createDate between '2016-07-11 00:00:00' and '2016-07-11 23:59:59'
--随心买新增-累计总金额
union all select SUM(amount) from HUR_Product_Buy where createDate between '1980-01-01' and '2016-07-11 23:59:59'


--随心买退出-当日人次
union all select COUNT(*) from(select distinct userID from HUR_Product_Buy where (status=2 or status=3) and updateDate between '2016-07-11 00:00:00' and '2016-07-11 23:59:59') as c
--随心买退出-累计总人次
union all select COUNT(*) from(select distinct userID from HUR_Product_Buy where (status=2 or status=3) and updateDate between '1980-01-01' and '2016-07-11 23:59:59') as d

--随心买退出-当日金额
union all select SUM(amount) from HUR_Product_Buy where (status=2 or status=3) and updateDate between '2016-07-12 00:00:00' and '2016-07-12 23:59:59'
--随心买退出-累计总金额
union all select SUM(amount) from HUR_Product_Buy where (status=2 or status=3) and updateDate between '1980-01-01' and '2016-07-12 23:59:59'

 

 

 


select * from(
select ext.exitID,ext.exitAmount,ext.createDate,ext.exitStatus,
(select username from YYD_Users_RegInfo where id = ext.userID) username,
(select amount from HUR_Product_Buy where buyID = ext.buyID) amount,
(select rankName from HUR_Product_Buy where buyID = ext.buyID) rankName
from HUR_Product_Exit as ext) as data where 1=1

select * from HUR_Product_Buy order by createDate desc

select SUM(amount) as TotalextAmount from(select buy.buyID,buy.amount,buy.status,buy.platform,buy.updateDate,
(select username from YYD_Users_RegInfo where id = buy.userID) username from HUR_Product_Buy as buy where (status=2 or status=3)) as data

where username like '%dd%'


select buy.buyID,buy.amount,buy.status,buy.platform,buy.updateDate,
(select username from YYD_Users_RegInfo where id = buy.userID) username from HUR_Product_Buy as buy where (status=2 or status=3)



posted @ 2016-07-25 15:36  从未被超越  阅读(208)  评论(0编辑  收藏  举报