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,
t.getinfodate,
t.salesman,
t.isoperationcar,
t.iscoverplace,
t.isbuttjoint,
t.operatesituation,
t.platenumber,
t.inforimportdate,
t.customertype,
t.iscanbuttjoint,
t.re
from t_o_dayvehicle t ) a
where rownum <= 15)
where rn > 0来个老问题。报ORA-00918:column ambiguously defined
知道列重复,可是我就这一张表查询阿,怎么会报错呢?我把 t.platenumber,随便写一个 t.platenumber as gh就可以了。但是是t.platenumber as platenumber就报这鸟错误阿。Shit!@
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,
t.getinfodate,
t.salesman,
t.isoperationcar,
t.iscoverplace,
t.isbuttjoint,
t.operatesituation,
t.platenumber,
t.inforimportdate,
t.customertype,
t.iscanbuttjoint,
t.re
from t_o_dayvehicle t ) a
where rownum <= 15)
where rn > 0来个老问题。报ORA-00918:column ambiguously defined
知道列重复,可是我就这一张表查询阿,怎么会报错呢?我把 t.platenumber,随便写一个 t.platenumber as gh就可以了。但是是t.platenumber as platenumber就报这鸟错误阿。Shit!@
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货