SELECT IDENTITY(INT,0,1) AS MXBH,* INTO 临时表 FROM 源表 order by 排序SELECT TOP 10 * FROM 临时表 where MXBH>=序号
