求解！1条语句分10部分查询！

[tianxia198909]

select z.lxr,z.lxrdh,z.dzhdh,k.spmch ,x.danjbh, z.bqdfj
from int_ddhz as z,spkfk as k,int_ddmx as x
where x.spid =k.spid and z.danjbh =x.danjbh
就是把语句修改一下
把结果分十部分查出

[tianxia198909]

呃 ！！用我那个语句写啊 ！ 写出来给你分啊

[争取今天]

set pagesize 20;

[andyguan01_2]

移到sqlserver版块去吧。

[tianxia198909]

补充一下 打错了！是分页查询！ 分10页查询！sql server2008

[大明湖畔_帅锅]

oracle分页查询

SELECT * FROM 
(
SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM TABLE_NAME) A --不排序
WHERE ROWNUM <= 40
)
WHERE RN >= 21;

SELECT *
FROM (SELECT a.*, row_number() over(ORDER BY 1) rn --假排序，速度同上
FROM t1 a)
WHERE rn BETWEEN 21 AND 40;

SELECT *
FROM (SELECT a.*, row_number() over(ORDER BY c1) rn --真实排序，无法比较速度
FROM t1 a)
WHERE rn BETWEEN 21 AND 40;

[大明湖畔_帅锅]

[Quote=引用 1 楼 tianxia198909 的回复:]

补充一下 打错了！是分页查询！ 分10页查询！sql server2008
[/Quote]


大哥 sql server2008？ 这里是 Oracle-基础和管理 会混淆得

[我心飞翔]

请参考：

-- 创建视图
CREATE VIEW ViewTemp AS 
(select z.lxr,z.lxrdh,z.dzhdh,k.spmch ,x.danjbh, z.bqdfj
from int_ddhz as z,spkfk as k,int_ddmx as x  
where x.spid =k.spid and z.danjbh =x.danjbh);
-- 查询
SELECT top n * FROM ViewTemp
WHERE 主键 NOT IN (SELECT top m 主键 FROM ViewTemp)