回複：如果要求第8行的結果

來源: 於 2004-01-12 12:41:00 [舊帖] [給我悄悄話] 本文已被閱讀：次

SELECT IDENTITY(int, 1,1) AS row_Num
, au_id
into #authors
FROM pubs..authors
GO

select *
from
pubs..authors a1
, #authors a2
where
a1.au_id = a2.au_id
and a2.row_Num = 8
Go

drop table #pubs
GO



--文學城www.wenxuecity.com--