haitao · 2006-09-18 15:57:47 · 阅读: 794 select top m * from select top m * from (select top n * from tb order by f1,f2 desc,f3/*反序*/) a order by f1 desc,f2,f3 desc/*正序*/ n=总数-20 m=20