取出表test中前30到40的数据按id排列。
16 查阅
参考答案:
select top20 from test where id not in(select top20 from test order by id) order by id
参考答案:
select top20 from test where id not in(select top20 from test order by id) order by id