select 消费项目,sum(数量) as 数量,sum(金额) as 合计金额 from 收银表
where CAST ( 时间+' '+日期 as datetime) >'2004-01-02 12:00:00' and
CAST ( 时间+' '+日期 as datetime) <'2004-01-03 12:00:00' group by 消费项目
where CAST ( 时间+' '+日期 as datetime) >'2004-01-02 12:00:00' and
CAST ( 时间+' '+日期 as datetime) <'2004-01-03 12:00:00' group by 消费项目
from 收银表
where 日期+' '+时间>='2004-01-02 12:00:00'
and 日期+' '+时间<'2004-01-03 12:00:00'
select 消费项目,sum(数量) as 数量,sum(金额) as 合计金额
from 收银表
where 日期>='2004-01-02' and 时间>='12:00:00'
and 日期<='2004-01-02' and 时间<'12:00:00'