sqlserver 查询数据显示行号

最新推荐文章于 2024-05-30 19:46:53 发布

lmy_loveF

最新推荐文章于 2024-05-30 19:46:53 发布

阅读量1.7k

点赞数

文章标签： sqlserver

本文链接：https://blog.youkuaiyun.com/lmy_loveF/article/details/132740505

版权

该篇文章介绍了如何在SQL查询中使用ROW_NUMBER()函数为WAGES_INCOME_TAX_DIFFERENCE表中的数据增加行号，并对工资、税收等字段进行了聚合计算和排序，以展示详细统计数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查询的数据需要增加一个行号

SELECT 
        ROW_NUMBER() OVER(ORDER BY witd_wages_area ,
        witd_wages_type ,
        witd_department_id ,
        witd_give_out_time) '行号',
        ISNULL(witd_wages_area, 0) witd_wages_area ,
        witd_wages_type ,
        witd_department_id ,
        ISNULL(CONVERT(VARCHAR(7), witd_give_out_time, 23), '') witd_give_out_time ,
        SUM(CONVERT(BIGINT, witd_id)) AS witd_id ,
        SUM(CONVERT(BIGINT, witd_id) / 1000) AS witd_id_sub ,
        COUNT(*) AS [count] ,
        SUM(CONVERT(BIGINT, witd_taxsys_income_amount)) AS witd_taxsys_income_amount ,
        SUM(CONVERT(BIGINT, witd_taxsys_tax_amount)) AS witd_taxsys_tax_amount ,
        SUM(CONVERT(BIGINT, witd_income_amount)) AS witd_income_amount ,
        SUM(CONVERT(BIGINT, witd_tax_amount)) AS witd_tax_amount ,
        SUM(CONVERT(BIGINT, witd_diff_amount)) AS witd_diff_amount
FROM    WAGES_INCOME_TAX_DIFFERENCE
WHERE   1 = 1
GROUP BY witd_wages_area ,
        witd_wages_type ,
        witd_department_id ,
        witd_give_out_time
ORDER BY witd_wages_area ,
        witd_wages_type ,
        witd_department_id ,
        witd_give_out_time