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

Popular posts from this blog

.htaccess - First slash is removed after domain when entering a webpage in the browser -

Automatically create pages in phpfox -

c# - Farseer ContactListener is not working -