日期:2014-05-17  浏览次数:20823 次

报ORA-00918:column ambiguously defined错误
select *
  from (select a.*,rownum rn 
          from (select t.vrid,
                       t.province,
                       t.customer,
                       t.cartypecode,
                       t.engine,
                       t.carnumber,
                       t.gboscode,
                       t.v3gvideocode,
                       
                       t.enginenumber,
                       t.vincode,
                       
                       t.platenumber,
                       
                       t.sensorcharcoefficient,
                       t.factk,
                       
                       t.theoryk,
                       t.tireradius,
                       t.backbridgespeed,
                       t.softmathk,
                       t.kissueddate,
                       t.installdate,
                       t.equmentchange,
                       t.installplace,
&nb