如何为依赖于其他两列的列赋予No [英] How to give No to columns which is depend on two others column

问题描述

我的数据如下：



IPO_No Item_No Line_Item_Seq_No Release_No

15063 11104 1 1

15063 11104 1 1

15063 11104 1 1





所以我想发布不会显示像1,2， 3 ...不是1,1,1。

请帮帮我

I have data like :

IPO_No Item_No Line_Item_Seq_No Release_No
15063 11104 1 1
15063 11104 1 1
15063 11104 1 1


so i want release no will display like 1,2,3...not 1,1,1.
Please help me

推荐答案

你好，



请尝试以下查询并告诉我它是否有帮助。

Hello,

Please try below query and let me know if it helps your need.

with ctetest  (IPO_No,Item_No   ,Line_Item_Seq_No  ,Release_No) as
(
select 15063    AS IPO_No, 11104    as Item_No  ,1 as   Line_Item_Seq_No  ,1 as Release_No
union all
select 15063    AS IPO_No, 11104    as Item_No  ,1 as   Line_Item_Seq_No  ,1 as Release_No
union all
select 15063    AS IPO_No, 11104    as Item_No  ,1 as   Line_Item_Seq_No  ,1 as Release_No
)

select IPO_No,Item_No,Line_Item_Seq_No,ROW_NUMBER() over (order by IPO_No asc) Release_No from ctetest

谢谢，

Hitesh Varde

Thanks,
Hitesh Varde

这篇关于如何为依赖于其他两列的列赋予No的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！