语句:
select 三十分钟以内=case when datediff( minute, bcgckssj,bcgcjssj)<30 then yq end,
一小时以内=case when datediff( hour, bcgckssj,bcgcjssj)<1 and datediff( minute, bcgckssj,bcgcjssj)<30 then yq end,
三小时以内=case when datediff( hour, bcgckssj,bcgcjssj)<3 and datediff( hour, bcgckssj,bcgcjssj)<1 then yq end,
六小时以内=case when datediff( hour, bcgckssj,bcgcjssj)<6 and datediff( hour, bcgckssj,bcgcjssj)<3 then yq end ,
十二小时以内=case when datediff( hour, bcgckssj,bcgcjssj)<12 and datediff( hour, bcgckssj,bcgcjssj)<6 then yq end,
二十四小时以内=case when datediff( day, bcgckssj,bcgcjssj)<1 and datediff( hour, bcgckssj,bcgcjssj)<12 then yq end
from OGCXQJDJSGCSJJLB;
select bcgckssj,三十分钟以内=case when datediff( minute, bcgckssj,bcgcjssj)<30 then yq end,
bcgckssj,一小时以内=case when datediff( hour, bcgckssj,bcgcjssj)<1 and datediff( minute, bcgckssj,bcgcjssj)<30 then yq end,
bcgckssj,三小时以内=case when datediff( hour, bcgckssj,bcgcjssj)<3 and datediff( hour, bcgckssj,bcgcjssj)<1 then yq end,
bcgckssj,六小时以内=case when datediff( hour, bcgckssj,bcgcjssj)<6 and datediff( hour, bcgckssj,bcgcjssj)<3 then yq end ,
bcgckssj,十二小时以内=case when datediff( hour, bcgckssj,bcgcjssj)<12 and datediff( hour, bcgckssj,bcgcjssj)<6 then yq end,
select bcgckssj,yq,三十分钟以内=case when datediff( minute, bcgckssj,bcgcjssj)<30 then '三十分钟以内'
when datediff( hour, bcgckssj,bcgcjssj)<1 and datediff( minute, bcgckssj,bcgcjssj)<30 then '一小时以内'
when datediff( hour, bcgckssj,bcgcjssj)<3 and datediff( hour, bcgckssj,bcgcjssj)<1 then '三小时以内'
when datediff( hour, bcgckssj,bcgcjssj)<6 and datediff( hour, bcgckssj,bcgcjssj)<3 then '六小时以内'
when datediff( hour, bcgckssj,bcgcjssj)<12 and datediff( hour, bcgckssj,bcgcjssj)<6 then '十二小时以内'
when datediff( day, bcgckssj,bcgcjssj)<1 and datediff( hour, bcgckssj,bcgcjssj)<12 then '二十四小时以内'
end
from OGCXQJDJSGCSJJLB;
bcgckssj,二十四小时以内=case when datediff( day, bcgckssj,bcgcjssj)<1 and datediff( hour, bcgckssj,bcgcjssj)<12 then yq end
from OGCXQJDJSGCSJJLB;