sql case分支语句练习

语句：

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;