Question

ASP复杂读取问题:怎么实现不读取前3条记录

如：数据库
ID dj txt
1 32 aaa
2 43 bbb
3 12 ccc
4 73 ddd
5 23 eee
asp 读取问题
1. 怎么实现不读取dj最大的前3个 ，按ID排序
2. 怎么实现读取dj最大的前3个，按ID排序

Answer 1

比较笨的方法 笑纳
1.
rs=conn.execute(" select * from table order by dj desc ,id desc")
totalcount=rs.count-3
rs=conn.execute(" select top "&totalcount&" * from table order by dj asc ,id desc")
2.
rs=conn.execute(" select top 3 * from table order by dj desc ,id desc")

Answer 2

1.select * from table where ID not in(select top 3 ID from table order by dj desc) order by ID asc
2.select * from (select top 3 * from table order by dj desc) order by ID asc