Help about a SQL statement - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Help about a SQL statement

Help about a SQL statement# Database - 数据库

c*j2004-01-20 08:01

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*i2004-01-20 08:01

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*j2004-01-20 08:01

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*i2004-01-20 08:01

4 楼

SORRY，我的是ORACLE的

【在 c******j 的大作中提到】

: SQL server doesn't support rownum:(

c*j2004-01-20 08:01

5 楼

Thanks anyway:-)

【在 h******i 的大作中提到】

: SORRY，我的是ORACLE的

D*N2004-01-20 08:01

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:-)

2024-01-28 18:01

2024-01-09 19:01

2024-01-07 18:01

2024-01-06 18:01

2024-01-06 18:01

2023-12-13 17:12

2023-12-02 07:12

2023-11-26 18:11

中美航班重磅消息！每周85班，直飞更方便！

微软、亚马逊、谷歌大裁员！哪些科技和零售公司有缩减规模计划？

中国外长王毅：中美关系已经止跌回稳

脱轨事故造成20多人受伤联邦调查纽约市全部地铁系统

更多 2024-05-16 的新闻