分时间段查询销售总量

最新推荐文章于 2022-09-30 10:44:30 发布

萨尼莫

最新推荐文章于 2022-09-30 10:44:30 发布

阅读量551

点赞数

分类专栏： sql

本文链接：https://blog.csdn.net/wuzy0430/article/details/54933150

版权

sql 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

insert into testdd(ids,names,resid,dates) values(2,'qw','123456', to_date('2017/2/7 00:10:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(3,'qw','123456', to_date('2017/2/7 01:10:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(4,'qw','123456', to_date('2017/2/7 01:20:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(5,'qw','123456', to_date('2017/2/7 02:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(6,'qw','123456', to_date('2017/2/7 03:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(7,'qw','123456', to_date('2017/2/7 04:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(8,'qw','123456', to_date('2017/2/7 05:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(9,'qw','123456', to_date('2017/2/7 06:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(10,'qw','123456', to_date('2017/2/7 07:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(11,'qw','123456', to_date('2017/2/7 08:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(12,'qw','123456', to_date('2017/2/7 09:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(13,'qw1','1123456', to_date('2017/2/7 10:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(14,'qw','123456', to_date('2017/2/7 11:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(15,'qw','123456', to_date('2017/2/7 12:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(16,'qw','123456', to_date('2017/2/7 13:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(17,'qw','123456', to_date('2017/2/7 14:00:00', 'yyyy-mm-dd hh24:mi:ss'));
insert into testdd(ids,names,resid,dates) values(18,'qw','123456', to_date('2017/2/7 15:00:00', 'yyyy-mm-dd hh24:mi:ss'));

select count(d.ids),d.time_line from
(select ids,to_char(dates,'hh24') time_line from testdd )d
group by d.time_line order by d.time_line;

--sum(sal) over (partition by deptno order by ename)

select * from testdd