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
就是把语句修改一下
把结果分十部分查出
from int_ddhz as z,spkfk as k,int_ddmx as x
where x.spid =k.spid and z.danjbh =x.danjbh
就是把语句修改一下
把结果分十部分查出
(
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;
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)