超市 卖场 总计
日期 客数 销售收入 客单价 客数 销售收入 客单价 客数 销售收入 客单价
一些有关数据提供给大家,多谢了。
查询超市的数据sql语句如下:splsyjid 是“收银机编号”
select spldate "日期",sum(splxsbs1) "客数",sum(splxssr ) "销售收入",round(sum(splxssr )/sum(splxsbs1),2) "平均客单价" from saleposlist where splsyjid between 9101 and 9130 and trunc(spldate)=to_date‘20061205’,'yyyymmdd') group by spldate查询卖场的数据sql语句如下:
select spldate "日期",sum(splxsbs1) "客数",sum(splxssr ) "销售收入",round(sum(splxssr )/sum(splxsbs1),2) "平均客单价" from saleposlist where splsyjid between 8131 and 8152 and trunc(spldate)=to_date(‘20061205’,'yyyymmdd') group by spldate查询总计的数据sql语句如下:
select spldate "日期",sum(splxsbs1) "客数",sum(splxssr ) "销售收入",round(sum(splxssr )/sum(splxsbs1),2) "平均客单价" from saleposlist where trunc(spldate)=to_date((‘20061205’,'yyyymmdd') group by spldate
日期 客数 销售收入 客单价 客数 销售收入 客单价 客数 销售收入 客单价
一些有关数据提供给大家,多谢了。
查询超市的数据sql语句如下:splsyjid 是“收银机编号”
select spldate "日期",sum(splxsbs1) "客数",sum(splxssr ) "销售收入",round(sum(splxssr )/sum(splxsbs1),2) "平均客单价" from saleposlist where splsyjid between 9101 and 9130 and trunc(spldate)=to_date‘20061205’,'yyyymmdd') group by spldate查询卖场的数据sql语句如下:
select spldate "日期",sum(splxsbs1) "客数",sum(splxssr ) "销售收入",round(sum(splxssr )/sum(splxsbs1),2) "平均客单价" from saleposlist where splsyjid between 8131 and 8152 and trunc(spldate)=to_date(‘20061205’,'yyyymmdd') group by spldate查询总计的数据sql语句如下:
select spldate "日期",sum(splxsbs1) "客数",sum(splxssr ) "销售收入",round(sum(splxssr )/sum(splxsbs1),2) "平均客单价" from saleposlist where trunc(spldate)=to_date((‘20061205’,'yyyymmdd') group by spldate
解决方案 »
- 执行单步跟踪的时候出现系统错误
- 孤立词语音识别过程中的录音的问题
- 如何提高远程访问的速度
- 如何使我的程序在执行时,响应MOUSE
- 我从filelistbox拖放多个文件到treeview,结果treeview什么都显示不出,求教我得错误之处!!
- 关于取其它程序控件文本的问题
- 急死人了!!!如何在编辑框中输入二氧化硫的分子式???高手一定要来救命啊!
- delphi菜鸟问:最近新建一个工程,运行后,关掉时速度很慢?why?
- dd
- 一个简单的本地(一台机器上调试)server/client通讯程序,怎样在两个server和client中同时设断点交互调试呢?
- 老版的dxgrid在哪里可以下载倒?
- 网上盛传的"IT业进销存管理系统"源码大家看过吗?
sum(case when splsyjid between 9101 and 9130 then splxsbs1 else 0 end ) "超市客数",
sum(case when splsyjid between 9101 and 9130 then splxssr else 0 end ) "超市销售收入",
sum(case when splsyjid between 9101 and 9130 then splxsbs1 else 0 end )/
sum(case when splsyjid between 9101 and 9130 then splxssr else 0 end ) "超市总平均客单价",
sum(case when splsyjid between 8132 and 8152 then splxsbs1 else 0 end ) "超市客数",
sum(case when splsyjid between 8132 and 8152 then splxssr else 0 end ) "超市销售收入",
sum(case when splsyjid between 8132 and 8152 then splxsbs1 else 0 end )/
sum(case when splsyjid between 8132 and 8152 then splxssr else 0 end ) "超市总平均客单价",
sum(splxsbs1) "总客数",
sum(splxssr ) "总销售收入",
round(sum(splxssr )/sum(splxsbs1),2) "总平均客单价"
from saleposlist
where trunc(spldate)=to_date((‘20061205’,'yyyymmdd') group by spldate