写出一条Sql语句：取出表Customer中第31到第40记录（SQLServer,以自动增长的Id作为主键,注意：Id可能不是连续的。
写出一条Sql语句：取出表Customer中第31到第40记录（SQLServer,以自动增长的Id作为主键,注意：Id可能不是连续的。
select top 10 * from (select ROW_NUMBER() over(order by Id) as rows,* from Customer) as C where C.rows>30 order by Id
select top 10 * from Customer where id not in(select top 30 Id from Customer order by Id)order by Id
select top 10 * from Customer where id>(select MAX(Id) from (select top 30 Id from CUstomer order by Id) as Customer) order by Id
版权声明：本文为zhubangchao原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。