select case when ... case when ... ..., count(1) from tb group by case when ... case when ... ...
SELECT * FROM TB WHERE DATEPART(HH,DATE) >=0 AND DATEPART(HH,DATE) <8 UNION ALL SELECT * FROM TB WHERE DATEPART(HH,DATE) >=8 AND DATEPART(HH,DATE) <16 UNION ALL SELECT * FROM TB WHERE DATEPART(HH,DATE) >=16 AND DATEPART(HH,DATE) <=24这样???
select 日期, max(case when datepart(hh,时间) between 0 and 7 then 数据 else 0 end) as '0:00-8:00 ', max(case when datepart(hh,时间) between 8 and 15 then 数据 else 0 end) as '8:00-16:00 ', max(case when datepart(hh,时间) between 16 and 24 then 数据 else 0 end) as '16:00-24:00 ' from tb group by 日期
case when ...
case when ...
...,
count(1)
from tb
group by
case when ...
case when ...
...
SELECT *
FROM TB
WHERE DATEPART(HH,DATE) >=0 AND DATEPART(HH,DATE) <8
UNION ALL
SELECT *
FROM TB
WHERE DATEPART(HH,DATE) >=8 AND DATEPART(HH,DATE) <16
UNION ALL
SELECT *
FROM TB
WHERE DATEPART(HH,DATE) >=16 AND DATEPART(HH,DATE) <=24这样???
日期,
max(case when datepart(hh,时间) between 0 and 7 then 数据 else 0 end) as '0:00-8:00 ',
max(case when datepart(hh,时间) between 8 and 15 then 数据 else 0 end) as '8:00-16:00 ',
max(case when datepart(hh,时间) between 16 and 24 then 数据 else 0 end) as '16:00-24:00 '
from
tb
group by
日期
SQL 输入查询语句datepart(hh,filetime)时提示ora-00904 “datepart”无效的标识符
还有5楼链接里的帖子我看了下,不太懂。
能否麻烦各位在给我解答一下,如果方便,请加我qq:839095685