超市 卖场 总计
日期 客数 销售收入 客单价 客数 销售收入 客单价 客数 销售收入 客单价
一些有关数据提供给大家,多谢了。
查询超市的数据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
解决方案 »
- dbgrid 如何显示带有子表的表
- Date型 如何转换成varchar啊?高手指点下,简单问题 高分高分!!!
- 急、急、急:怎样使TreeView上邦定值时速度更快些?
- 我做了一个DLL,他的主要工作是向串口发送数据,并得到串口的数据。它是不能使用界面的。我用了控件SPCOMM。
- delphi向数据库写数据的问题,谢谢!!
- delphi中cxgrid列添加checkbox
- SOS:求助水晶報表(crystal report)封裝問題
- 问关于dbgrid.selectedrows
- ASP.NET的简单问题
- 调用存储过程的小问题
- 有没有delphi操作excel的高手,请来江湖救急!
- 已知屏幕上的三个点(三角形的三个坐标点):求角平分线上的点的坐标
sum(case when sqleposlist between 9101 and 9130 then splxsbs1 else 0 end) "超市客数",
sum(case when sqleposlist between 9101 and 9130 then splxssr else 0 end) "超市销售收入",
round(sum(case when sqleposlist between 9101 and 9130 then splxsbs1 else 0 end)/
sum(case when sqleposlist between 9101 and 9130 then splxssr else 0 end)) "超市客单价",sum(case when sqleposlist between 8131 and 8152 then splxsbs1 else 0 end) "超市客数",
sum(case when sqleposlist between 8131 and 8152 then splxssr else 0 end) "超市销售收入",
round(sum(case when sqleposlist between 8131 and 8152 then splxsbs1 else 0 end)/
sum(case when sqleposlist between 8131 and 8152 then splxssr else 0 end)) "超市客单价",sum(splxsbs1) "客数",sum(splxssr ) "销售收入",
round(sum(splxssr )/sum(splxsbs1),2) "平均客单价"
from saleposlist where spldate=convert(varchar(10),'20061205',112)
group by spldate
from saleposlist where trunc(spldate) between to_date('20061206','yyyymmdd') and to_date('20061208','yyyymmdd')
group by spldate