摘要:
实际中用到的SQL:select * from (select top 3 Id,case when startSignup>GETDATE() then '敬请期待' when (startSignup=getdate()) then '正在报名' when (StartDate=GETDATE(... 阅读全文
摘要:
1.select sum(CASE WHEN A.[STATUS]=0 THEN 1 ELSE 0 end) as a1,sum(CASE A.[STATUS] WHEN 1 THEN 1 ELSE 0 end) as a2,sum(CASE A.[STATUS] WHEN 2 THEN 1 ELS... 阅读全文