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