ORACLE 查重复值

ORACLE 查重复值

select count(t.id) from torder t where t.mobile_no in (
       select t1.mobile_no from torder t1  group by t1.mobile_no having count(t1.mobile_no) > 1
)

ORACLE 分页

SELECT * FROM
 (SELECT A.*, ROWNUM RN FROM (
         SELECT t.id, t.freight_no ,t.address,t.order_type, t.company_id,t.receivable,t.payable
          FROM tb_order t left join tb_order_delivery od on od.id = t.order_delivery_id
          where od.id < 10000) A
 WHERE ROWNUM <= 12 )
WHERE RN >= 0