SELECT * FROM table1 a WHERE (SELECT COUNT(*) FROM table1 b WHERE b.id<=a.id) BETWEEN XXX AND XXX
select top xxx id from table as a where EXISTS(select top xxx id from table as b where b.id = a.id order by id desc) order by id desc 用EXISTS要比用IN 特别是对大批量,数据效率要高很多。
FROM table1 a
WHERE
(SELECT COUNT(*)
FROM table1 b
WHERE b.id<=a.id)
BETWEEN XXX AND XXX
用EXISTS要比用IN
特别是对大批量,数据效率要高很多。