上周﹐被一位網(wǎng)友問到在sql2000中，想選取一張表的第Ｎ條記錄怎麼寫?(即如下語句select ID,Name,Title from WebSite order by ID desc 如何改寫以達(dá)到目的)
我當(dāng)時(shí)直接就給他回
select ID,Name,Title from WebSite where ID= N
最后這位老兄說如果是ＩＤ是連續(xù)的話就可以，如果有記錄刪除的話，ＩＤ不連續(xù)了，就不行了 ,至此才明白他的真正意思。剛好要輪到公司的周會時(shí)間﹐于是想了一下。給出如下答案給他﹕

-- select top 1 [ID],[Name,Title from WebSite
-- where not  [ID] in (select top   11 [ID] from  WebSite order by [ID] asc)  order by [ID] asc
Declare @strSql Varchar(200),@intTopN int
Set @intTopN = 11
Set  @strSql = 'select top 1 [ID],[Name,Title from WebSite where not  [ID] in (select top  '+Cast(@intTopN  As Varchar(10))+'   [ID] from  WebSite order by [ID] asc)  order by [ID] asc'
PRint @strSql
Exec(@strSql)

做完之后﹐總感覺應(yīng)該會有更好的解決方案﹐可又一時(shí)想不出來!將其放在這里﹐供各位討論拍磚﹐如有最佳方案也請網(wǎng)友們不吝指教!
http://www.cnblogs.com/jinliangliu/archive/2006/09/11/501007.html