sql - How can I create one column in my select output with sequence and seed -
i have 1 select this
select top (5) row_number() over(order s.id) rownumber ,s.subscribenumber sn billing.subscribe s order s.id that have output this
rownumber sn -------------------- -------- 1 01100017 2 01100025 3 01100033 4 01100041 5 01100050 (5 row(s) affected) and have select this
select row_number() over(order s.id) rownumber ,s.subscribenumber sn billing.subscribe s order s.id offset (5) rows fetch next (5) rows only; that have output this
rownumber sn -------------------- -------- 6 01100068 7 01100076 8 01100084 9 01100092 10 01100106 (5 row(s) affected) how can union 2 select , result this
rownumber sn -------------------- -------- 1 01100017 6 01100068 2 01100025 7 01100076 3 01100033 8 01100084 4 01100041 9 01100092 5 01100050 10 01100106 (10 row(s) affected)
select * ( select top (5) row_number() over(order s.id) rownumber ,s.subscribenumber sn billing.subscribe s union select top 5 row_number() over(order s.id) rownumber ,s.subscribenumber sn billing.subscribe s order s.id offset (5) rows fetch next (5) rows ) x order (rownumber-1)%5, rownumber; edit: works now
Comments
Post a Comment