小弟有份資料,依下列語法寫出來資料格式SN會連續序號顯示(如:原資料顯示格式)...
原SQL語法
[code sql]
SELECT ROW_NUMBER() OVER (ORDER BY (TD004)DESC)SN, TD004, ONE
FROM(
SELECT (TC001 '-' TC002 '-' TD003)ONE, TD004
FROM bueno002..PURTC B1
INNER JOIN bueno002..PURTD B2
ON TC001=TD001 AND TC002=TD002 AND TD038='2'
WHERE TC014=N'Y' AND TC003 BETWEEN '20170101'AND'20171231' AND (B2.TD200 <> '0' AND B2.TD201 <> '')
AND B2.TD004 LIKE '2A%'
)TW
GROUP BY TD004, ONE --TD005,TD006,TD008,TD009,TD010,TD011
ORDER BY TD004 DESC

[/code]

SN TD004 ONE
2 2A700000002 A330-20170223006-0001
4 2A700000002 A330-20170718001-0001
6 2A680100000 A330-20170221001-0001
8 2A480300001 A331-20170106002-0001
10 2A480300001 A331-20170321003-0001
12 2A420100001 A330-20170704006-0001
14 2A340100008 A330-20171025008-0001
希望資料顯示格式
1 2A740100000 M330-20170214002-0001
2 2A700000002 A330-20170619005-0001
1 2A680100000 A330-20170202002-0001
1 2A670000000 A330-20170316004-0001
2 2A480300001 A331-20170215020-0001
1 2A420100001 A330-20170320007-0001
1 2A380100003 A330-20170831001-0001
2 2A340100008 A330-20171130006-0001

------

「Wish you all the best」謝謝

公司如果要尋找是一位系統維護人員，個人「工作態度」跟「執行力」相當有信心可以接任，
相信要「執行後穫得認同」就是一種工作上成就。

附加檔案：5a6ad307649de_SN資料顯示格式.xls

jslin你好, 

底下這段語法提供給你參考
SELECT ROW_NUMBER() OVER (PARTITION by td004 order by one)SN, TD004,one
from product
group by one,td004
ORDER BY TD004 desc,one

===================引 用 jslin 文 章===================
但希望是可以依"品號"分別產生SN序號(如:希望資料顯示

編輯記錄

非常感謝 不吝惜指教 ~~ OK  可以了
謝謝 !!

[code sql]
SELECT ROW_NUMBER() OVER (PARTITION BY TD004 ORDER BY (TD004)DESC)SN, TD004, ONE
FROM(
SELECT (TC001 '-' TC002 '-' TD003)ONE, TD004
FROM bueno002..PURTC B1
INNER JOIN bueno002..PURTD B2
ON TC001=TD001 AND TC002=TD002 AND TD038='2'
WHERE TC014=N'Y' AND TC003 BETWEEN '20170101'AND'20171231' AND (B2.TD200 <> '0' AND B2.TD201 <> '') AND B2.TD004 LIKE '2A%'
)TW
GROUP BY TD004, ONE --TD005,TD006,TD008,TD009,TD010,TD011
ORDER BY TD004 DESC
[/code]

------

「Wish you all the best」謝謝

公司如果要尋找是一位系統維護人員，個人「工作態度」跟「執行力」相當有信心可以接任，
相信要「執行後穫得認同」就是一種工作上成就。