本文共 416 字，大约阅读时间需要 1 分钟。
select * from ( select a.*,rownum rn from ( select * from TAB_SYS_CARDCASE where oper_id = #{operId} and status = 1 and (phone like '%' || #{serchKey} || '%' or user_name like '%' || #{serchKey} || '%' ) order by id desc = #{start} ]]>
转载于:https://www.cnblogs.com/YuyuanNo1/p/7992565.html