别人的发明,看起来很不错,比较有想法:
select * from tblExternalProduct where ProductId in
( Select top 10 ProductId From (Select top 20 ProductId From tblExternalProduct order by productId desc) as ep order by ep.productid asc)order by productid desc
原文地址:
本文共 309 字,大约阅读时间需要 1 分钟。
别人的发明,看起来很不错,比较有想法:
select * from tblExternalProduct where ProductId in
( Select top 10 ProductId From (Select top 20 ProductId From tblExternalProduct order by productId desc) as ep order by ep.productid asc)order by productid desc
原文地址:
转载于:https://www.cnblogs.com/sadsheep/archive/2012/06/27/2565947.html