请问以上查询在SQL2005 里分页查询写法？？？select * fromproduct where smallid+smallid+ order by pi
请问以上查询在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