想必現(xiàn)在有很多小伙伴對于Question6: How can I add row numbers to my result set? In database pubs, have a table titles , now I want the result shown as below,each row have a row number, how can you do that? Result: line-no title_id ----------- -------- 1 BU1032 2 BU1111 3 BU2075 4 BU7832 5 MC2222 6 MC3021 7 MC3026 8 PC1035 9 PC8888 10 PC9999 11 PS1372 12 PS2091 13 PS2106 14 PS3333 15 PS7777 16 TC321817 TC4203 18 TC7777","title_text":"Question6: How can I add row numbers to my result set? In database pubs, have a table titles , now I want the result shown as below,each row have a row number, how can you do that? Result: line-no title_id ----------- -------- 1 BU1032 2 BU1111 3 BU2075 4 BU7832 5 MC2222 6 MC3021 7 MC3026 8 PC1035 9 PC8888 10 PC9999 11 PS1372 12 PS2091 13 PS2106 14 PS3333 15 PS7777 16 TC321817 TC4203 18 TC7777方面的知識都比較想要了解，那么今天小好小編就為大家收集了一些關(guān)于Question6: How can I add row numbers to my result set? In database pubs, have a table titles , now I want the result shown as below,each row have a row number, how can you do that? Result: line-no title_id ----------- -------- 1 BU1032 2 BU1111 3 BU2075 4 BU7832 5 MC2222 6 MC3021 7 MC3026 8 PC1035 9 PC8888 10 PC9999 11 PS1372 12 PS2091 13 PS2106 14 PS3333 15 PS7777 16 TC321817 TC4203 18 TC7777","title_text":"Question6: How can I add row numbers to my result set? In database pubs, have a table titles , now I want the result shown as below,each row have a row number, how can you do that? Result: line-no title_id ----------- -------- 1 BU1032 2 BU1111 3 BU2075 4 BU7832 5 MC2222 6 MC3021 7 MC3026 8 PC1035 9 PC8888 10 PC9999 11 PS1372 12 PS2091 13 PS2106 14 PS3333 15 PS7777 16 TC321817 TC4203 18 TC7777方面的知識分享給大家，希望大家會喜歡哦。正確答案： Answer 6： --SQL 2005的寫法 select row_number() as line_no ,title_id from titles --SQL 2000的寫法 select line_no identity(int,1,1),title_id into #t from titles select * from #t drop table #t

本文到此結(jié)束，希望對大家有所幫助。

版權(quán)說明：本文由用戶上傳，如有侵權(quán)請聯(lián)系刪除！

標(biāo)簽：