c******j
发帖数: 87 | 1 SELECT TOP 1000 * FROM ....
can help to find the first 1000 records.
But how to find the second 1000, third 1000, etc, conveniently?
Thanks | h******i
发帖数: 133 | 2 it is easy, do like this:
select sss,bbb,...
from
(select sss,bbb,...., a.rownum rown
from M_table) b
where b.rown between 1000 and 2000
【在 c******j 的大作中提到】
: SELECT TOP 1000 * FROM ....
: can help to find the first 1000 records.
: But how to find the second 1000, third 1000, etc, conveniently?
: Thanks
| c******j
发帖数: 87 | 3 SQL server doesn't support rownum:(
【在 h******i 的大作中提到】
: it is easy, do like this:
: select sss,bbb,...
: from
: (select sss,bbb,...., a.rownum rown
: from M_table) b
: where b.rown between 1000 and 2000
| h******i
发帖数: 133 | 4 SORRY，我的是ORACLE的
【在 c******j 的大作中提到】
: SQL server doesn't support rownum:(
| c******j
发帖数: 87 | 5 Thanks anyway:-)
【在 h******i 的大作中提到】
: SORRY，我的是ORACLE的
| D****N
发帖数: 430 | 6 SELECT TOP 1000 *
FROM table_blah
WHERE
table_uid IN (SELECT TOP 2000 table_uid
FROM table_blah)
ORDER BY table_uid DESC
【在 c******j 的大作中提到】
: Thanks anyway:-)
|
|
