haitao: select top m * from [阅读: 764] 2006-09-18 07:57:47 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