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;
关于Oracle语句问题,在oracle中可以查 在映射的XML中不可以
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-