解决方案 »
- 关于调试oracle存储过程的工具 sys_cursor_viewer.exe
- 大数据量表关联查询 性能如何优化 请求帮忙!
- 求助:数据库表结构设计与平均转发的问题
- 空值数据排序问题
- 触发器的写法
- 在oracle 9i中,昨天还能打开的数据库mis不知道怎么回事打不开了,报如下网址的错误,请问是怎么回事啊?改怎样处理才能打开的数据库mis
- 请问,这个过程编译为什么有这个错误?
- 如何干掉 Oracle Servlet Engine?
- Oracle查询分析器2000 V1.1
- 如何将一个文档(包括文档的字体、表格、风格等)保存到数据库里?
- 存储过程执行太慢,求高手解答
- 一个SQL语句问题!求大神解答!!!
select 11 as personcount,to_date('2011-01-01','yyyy-mm-dd') As datetime from dual
union all
select 22 as personcount,to_date('2011-01-03','yyyy-mm-dd') As datetime from dual
union all
select 2 as personcount,to_date('2011-01-04','yyyy-mm-dd') As datetime from dual
union all
select 5 as personcount,to_date('2011-01-05','yyyy-mm-dd') As datetime from dual
)
select case when personcount >=0 And personcount <10 then '0-10'
when personcount >=10 And personcount <20 then '10-20'
when personcount >=20 And personcount <30 then '20-30' end as 分段,
sum(personcount) 总人数,count(distinct datetime) as 总天数
from t
group by case when personcount >=0 And personcount <10 then '0-10'
when personcount >=10 And personcount <20 then '10-20'
when personcount >=20 And personcount <30 then '20-30' end
select (personcount-1)/10 as fenduan,
sum(personcount) as sum_per,
count(distinct riqi) as tianshu
from tb_name
group by (personcount-1)/10
select 11 as personcount,to_date('2011-01-01','yyyy-mm-dd') As datetime from dual
union all
select 22 as personcount,to_date('2011-01-03','yyyy-mm-dd') As datetime from dual
union all
select 2 as personcount,to_date('2011-01-04','yyyy-mm-dd') As datetime from dual
union all
select 5 as personcount,to_date('2011-01-05','yyyy-mm-dd') As datetime from dual
)
select trunc( (personcount-1)/10) as 分段,
sum(personcount) as sum_per,
count(distinct datetime) as tianshu
from t
group by trunc((personcount-1)/10)
select to_char(trunc((111-1)/10))||'0-'||to_char(trunc((111-1)/10)+1)||'0' as fenduan,
sum(personcount) as sum_per,
count(distinct riqi) as tianshu
from tb_name
group by to_char(trunc((111-1)/10))||'0-'||to_char(trunc((111-1)/10)+1)||'0'
select to_char(trunc(abs(personcount-1)/10))||'0-'||to_char(trunc(abs(personcount-1)/10)+1)||'0' as fenduan,
sum(personcount) as sum_per,
count(distinct riqi) as tianshu
from tb_name
group by to_char(trunc(abs(personcount-1)/10))||'0-'||to_char(trunc(abs(personcount-1)/10)+1)||'0'