select id,date,
case when datediff(day,[date],getdate())<3 then '*'
when datediff(day,[date],getdate()) between 0 and 2 then '#'
when datediff(day,[date],getdate()) between 3 and 7 then '三角星'
else '五角星'
end
from tb
case when datediff(day,[date],getdate())<3 then '*'
when datediff(day,[date],getdate()) between 0 and 2 then '#'
when datediff(day,[date],getdate()) between 3 and 7 then '三角星'
else '五角星'
end
from tb
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货