Z
zealothasu
Unregistered / Unconfirmed
GUEST, unregistred user!
sql server
一個表,想在select 語句中加上一列
來表示這一行是第幾行
怎麼寫
如
White Johnson
Green Marjorie
Carson Cheryl
O'Leary Michael
Straight Dean
Smith Meander
Bennet Abraham
Dull Ann
Gringlesby Burt
Locksley Charlene
變成
White Johnson 1
Green Marjorie 2
Carson Cheryl 3
O'Leary Michael 4
Straight Dean 5
Smith Meander 6
Bennet Abraham 7
Dull Ann 8
Gringlesby Burt 9
Locksley Charlene 10
一個表,想在select 語句中加上一列
來表示這一行是第幾行
怎麼寫
如
White Johnson
Green Marjorie
Carson Cheryl
O'Leary Michael
Straight Dean
Smith Meander
Bennet Abraham
Dull Ann
Gringlesby Burt
Locksley Charlene
變成
White Johnson 1
Green Marjorie 2
Carson Cheryl 3
O'Leary Michael 4
Straight Dean 5
Smith Meander 6
Bennet Abraham 7
Dull Ann 8
Gringlesby Burt 9
Locksley Charlene 10