只保留小数点后两位。CONVERTVARCHAR ROUNDSUMCASE WHEN 日期 = 2023-03-14 THEN 总销量 END OVER PARTITION BY 大区 督导 ORDER BY 日期 大区 督导 1000 NULLIFSUMCASE WHEN 日期 = 2023-03-14 THEN 全产品销量 END OVER PARTITION BY 大区 督导 ORDER

The final result is converted to a string and rounded to two decimal places using the ROUND function. The percent sign is added to the end using concatenation. The final expression is:

CONVERT(VARCHAR, ROUND((SUM(CASE WHEN 日期 >= '2023-03-14' THEN 总销量 END) OVER (PARTITION BY 大区, 督导 ORDER BY 日期, 大区, 督导) * 100.0 / NULLIF(SUM(CASE WHEN 日期 >= '2023-03-14' THEN 全产品销量 END) OVER (PARTITION BY 大区, 督导 ORDER BY 日期, 大区, 督导), 0)), 2)) + '%'