请问以上查询在SQL2005 里分页查询写法？？？

select * from  product where smallid='"+smallid+"' order by pid desc

请问以上查询在SQL2005 里分页查询写法？？？


[解决办法]

select * from (
select row_number() over(order by pid desc) as rn, *  from product   where smallid=‘8888'
) a
where rn between 1 and 10