假如要查询的字段是ID，那么写法如下“
7-10：sql="select * from [xmtype] where id>6 and id<11 order by [nu]"
1-10：sql="select * from [xmtype] where id>0 and id<11 order by [nu]"
11-20：sql="select * from [xmtype] where id>10 and id<21 order by [nu]"
也可以写成 id>=7 and id<=10
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024