Question

ASP 查询显示除了前10记录 外的所有记录

<% set rs=server.CreateObject("ADODB.RecordSet") '创建记录集对象 rs.Source="select * from [_cate] where (number not in (select top 10 number from [_cate])) order by cateid"'查询所有符合条件的记录 rs.Open rs.Source,conn,1,1 '打开记录集对象 do while not rs.eof %>

Answer 1

select * from [_cate] where cateid not in(select top 10 id from [_cate] order by cateid)

麻烦采纳，谢谢!