SELECT * FROM (SELECT A.*, ROWNUM RN FROM (select e.company_name, e.company_id, e.company_logo, NVL(d.cnt, 0) from ((select company_name, company_id, company_logo from es_vote_company_info where 1 = 1 and auditing = '2') e left join (select count(1) cnt, t.company_id from es_vote_company_record t group by t.company_id order by cnt) d on d.company_id = e.company_id)) A WHERE ROWNUM <= 9) WHERE RN > 0;
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (select e.company_name, e.company_id, e.company_logo, NVL(d.cnt, 0) from ((select company_name, company_id, company_logo from es_vote_company_info where 1 = 1 and auditing = '2') e left join (select count(1) cnt, t.company_id from es_vote_company_record t group by t.company_id order by cnt) d on d.company_id = e.company_id)) A WHERE ROWNUM <= 18) WHERE RN > 9;