/****** Script for SelectTopNRows command from SSMS ******/ SELECT sum(a.fr_wc )as wc ,SUM(a.fr_ys)as ys, round(sum(a.fr_wc )/SUM(a.fr_ys),2)* 100 - 100 as b FROM( SELECT [yuefen] ,[bumen] ,[bumenid] ,[fr_wc] ,[fr_ys] ,[fr_bfb] FROM [new_jxkh].[dbo].[Vsr_yxh_bm_fr] where YEAR(yuefen) = 2019 AND MONTH(yuefen) = 1) a