没脾气2x · 2005-11-08 08:10:49 · 阅读: 523 21秒 SELECT * FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY 定单号 ) AS rownum, * FROM swindent ) s WHERE rownum > 323876 AND rownum < 323886