2 qq 31119063 qq_31119063 于 2016.02.20 15:30 提问

关于Oracle语句问题,在oracle中可以查 在映射的XML中不可以

select * from (
select siup.id,ROWNUM AS CON,siup.stationId, siup.stationName, siup.centerId, siup.centerName, tu.id userId, tu.name name, tu.certificatecode, tu.corpid corpId, corp.name corpName, dept.id deptId,
dept.name deptName, bu.id bulletinId, bu.title bulletinTitle, siup.workTypeId, wt.workname workTypeName, tu.photo, siup.signUpTime, siup.score
from tuser tu, tgroup corp, tuser_group tugr, tgroup dept, t_skex_signupinfo siup, t_skex_bulletin bu, worktype wt
where ROWNUM <= 3 and tu.corpid = corp.id and tu.id = tugr.user_id and tugr.group_id = dept.id and tu.id = siup.userid and siup.bulletinid = bu.id and siup.worktypeid = wt.id and siup.userid = #{userId}

and siup.auditRank > 2

order by siup.createtime desc
) where CON >= 1;

2个回答

qq_31119063
qq_31119063   2016.02.20 15:31

在线等。 映射的XML 中老是说CON 是无效的字符 但是我用Oracle 查询工具是可以查的 求大神

qq_31119063
qq_31119063   2016.02.20 15:33

来大神帮忙好不,求求

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!