Oracle重复数据通过排序取,分组数据，每个分组取10条数据，保持排序同时不能出现列重复数据...

SELECT  a.asset_id asset_id,

b.account_id account_id,

a.project_type  project_type,

a.rnoA,

b.rnoB,

DENSE_RANK() OVER(ORDER BY  a.rnoA) AS rn0,

ROW_NUMBER() OVER(PARTITION BY  a.rnoA ORDER BY b.rnoB ASC) rn1

FROM (SELECT a.*, rownum AS  rnoA

FROM (SELECT iaq.asset_id  asset_id,

iaq.project_type project_type,

iaq.end_date  asset_end_date,

iaq.rate  asset_rate,

fla.create_time asset_create_time,

fla.loan_money  - fla.already_money remain_money,

iaq.status,

fla.deadline  deadline,

fla.user_id  user_id

FROM  intel_asset_queue iaq

LEFT JOIN  fron_loan_application fla

ON fla.id =  iaq.asset_id

WHERE 1 = 1

AND fla.inner_type  = 0

AND iaq.ctr_status  != 9

AND fla.loan_money  >= fla.already_money

AND  fla.loan_status = 4<