摘要： 同期: CASE WHEN MONTH(acnt21.date) = 2 AND DAY(acnt21.date) = 29 AND NOT MOD( 1, 4 ) = 0 THEN (acnt21.date + 1 UNITS DAY) + 1 UNITS YEAR - 1 UNITS DAY ELSE acnt21.date + 1 UNITS YEAR END as date, 目的：... 阅读全文

摘要： select a.* , [增长率(%)] = ((a.数据 - b.数据)/b.数据)*100 from tb a left join tb b on a.日期 = dateadd(yy , 1 , b.日期)最好的计算方式是将日期直接计算出来，比如SELECT a.u_r_bf, a.u_y_bf,((a.u_y_bf-b.u_y_bf)*100/b.u_y_bf) u_y_bfbFROM h... 阅读全文