sql server2000 查重和显示行号问题

显示行号：

Select no=Identity(int,1,1),* Into #temptable From titles --Order By SortField
Select * From #temptable  --Where no>=6 And no < 10
Drop Table #temptable

查重：

use pubs

select au_lname from authors group by au_lname having count(1)>1