摘要： 原SQL：select ta.serialno, ta.accepttime, ta.subsnumber, ta.subsname, ta.contactphone1, ta.servicecontent, ta.address, r.region_name, s.contactchannel_name, p.name, p.fullname, rownum from (select t.serialno, t.accepttime, t.subsnumber, t.subsname, t.contactphone1, t.servicecontent, t.address, t.conta 阅读全文