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