select * from (
select RANK() OVER ( ORDER BY khbh asc,zjzh)num, * from dba.t_ddw_d_khdz t
)as a
where a.num>= 1 and a.num< 10
select RANK() OVER ( ORDER BY khbh asc,zjzh)num, * from dba.t_ddw_d_khdz t
)as a
where a.num>= 1 and a.num< 10