复合SQL

消费资料前10名
select distinct(xf_vipcode),count(xf_vipcode),max(xf_amtsold)
   from XF_VIPITEMDM
group by xf_vipcode 
   order by count(xf_vipcode) 
   desc

按品类分析查询 (两表关联复合查询)
select A.xf_ITEMCATEGORY,SUM(B.XF_AMTSOLD)
   from XF_VIPITEMDM B, Xf_Bscontracth A
where A.Xf_Storecode=B.XF_STORECODE
group by A.Xf_Itemcategory

免费排名，次数，消费金额汇总
select xf_vipcode,count(xf_vipcode),(select sum(xf_amtsold) from xf_vipitemdm where xf_vipcode=XF_BONUSLEDGER.Xf_Vipcode)
from XF_BONUSLEDGER
where xf_storecode='999998'
group by xf_vipcode
order by count(xf_vipcode)
desc

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7905232/viewspace-567108/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7905232/viewspace-567108/