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
Thanks,
Hitesh Varde