请帮å©ï¼å¤è°¢äºãå¤å¶æç´¢
追çselect * from table1 where xm = 'å¼ ä¸' and 积åæ¶é´ - 365 > (select top 1 积åæ¶é´ table1 where xm = 'å¼ ä¸' order by 积åæ¶é´ desc)ï¼å¤§çº¦æ¯è¿æ ·çã
è¦æ¯å积å å
select sum(è´ç©ç§¯å) from table1 where xm = 'å¼ ä¸' and 积åæ¶é´ - 365 > (select top 1 积åæ¶é´ table1 where xm = 'å¼ ä¸' order by 积åæ¶é´ desc)ï¼å¤§çº¦æ¯è¿æ ·çã
365æä¹è¡¨ç¤ºä¸å¹´æ¶é´ï¼ä½ èªå·±æ¥æ¥å»