DB2 增加排序行号

最新推荐文章于 2021-12-09 09:31:19 发布

BearMayCry

最新推荐文章于 2021-12-09 09:31:19 发布

阅读量2k

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/BearMayCry/article/details/84263508

版权

[b]
行号函数[/b]
ROW_NUMBER() OVER (ORDER BY 字段名) AS NUMBER

[b]实际例子保留[/b]
select a.* from (
select ROW_NUMBER() OVER (ORDER BY case when a.parent_kpi_id is null then b.kpi_value else 0 end desc) AS NUMBER,c.kpi_id,c.kpi_name,b.kpi_value,b.bgq,b.cbfybs,b.cbftbs,b.cbsptbs,b.cbrbs,b.report_id
from JXKH.REPORT_KPI_REALATION a
left join jxkh.kpi_value_2954 b on a.kpi_id = b.kpi_id and a.report_id = b.report_id and b.bgq=2012062020120719
left join jxkh.kpi_base_info c on c.kpi_id = a.kpi_id
where a.report_id = 11022 and b.cbsptbs is not null and b.cbrbs is null
and (a.parent_kpi_id = (select kpi_id from JXKH.REPORT_KPI_REALATION where parent_kpi_id is null and report_id = 11022) or a.parent_kpi_id is null)
) a where cbsptbs = 29540099