select * from ( select rownum temp_num,temp.* from ( select a.Year,ROW_NUMBER() OVER(ORDER BY d.EPCode, TO_NUMBER( a.ERName )) RowNum, a.ERUID,a.ERID,a.EPID,a.ERName,b.ERUName, d.EPName,d.EPCode, '第'+TO_CHAR(TO_NUMBER(SUBSTR(a.ERName,7,3)), '999')+'考场' CERName, TO_CHAR(a.StandCount, '99')+' 人' StandCount,a.ERUnitBuilding,a.ERUnitRoom,a.REMARK , case a.Combination when 1 then '3科' when 2 then '2科' when 3 then '1科' when 4 then '3科、2科' when 6 then '三种混合' else '1科、2科' end CombinationTypeText from tbExamRoot a INNER JOIN tbExamRoomUnit b on a.ERUID=b.ERUID and a.EPID=b.EPID LEFT JOIN tbYearEPoint c on a.Year=c.Year and a.EPID=b.EPID and b.EPID=c.EPID LEFT JOIN tbExamPoint d on a.EPID=d.EPID where 1=1 and a.Year='2011' ORDER BY d.EPCode, TO_NUMBER(a.ERName ) ) temp where rownum<=10) where temp_num>0
就是这句,请问哪里有错?
就是这句,请问哪里有错?
解决方案 »
- oracle版本环境移植!!!
- 求触发器(涉及三张表的求和汇总)
- 我如何吧我自己写的procedure 放在my objects中
- 通过odbc程序 往oracle数据库写 中文 乱码问题
- ORACLE怎么样复制数据库下的所有表的结构呢,不要数据?
- 想恢复数据啊!
- 为什么在执行建TRIGGER语句的时候会有Cannot create triggers on objects owned by SYS这样的提示?
- 如何用ADO访问linux下的Oracle数据库?
- 一个FORM BUILDER的TAB画布的问题
- 如何求95分位数:(函数,游标使用问题)
- 数据库主键生成问题,求解~谢谢
- 一个表的ID 到底用什么数据类型好?
先谢谢了!
select rownum temp_num
改为
select temp.rownum temp_num
试试.
from (select rownum temp_num, temp.*
from (select a.Year,
ROW_NUMBER() OVER(ORDER BY d.EPCode, TO_NUMBER(a.ERName)) RowNum,
a.ERUID,
a.ERID,
a.EPID,
a.ERName,
b.ERUName,
d.EPName,
d.EPCode,
'第' +
TO_CHAR(TO_NUMBER(SUBSTR(a.ERName, 7, 3)), '999') + '考场' CERName,
TO_CHAR(a.StandCount, '99') + ' 人' StandCount,
a.ERUnitBuilding,
a.ERUnitRoom,
a.REMARK,
case a.Combination
when 1 then
'3科'
when 2 then
'2科'
when 3 then
'1科'
when 4 then
'3科、2科'
when 6 then
'三种混合'
else
'1科、2科'
end CombinationTypeText
from (((tbExamRoot a INNER JOIN tbExamRoomUnit b
on(a.ERUID = b.ERUID and a.EPID = b.EPID)) LEFT JOIN
tbYearEPoint c on(a.Year = c.Year and a.EPID = b.EPID and
b.EPID = c.EPID)) LEFT JOIN
tbExamPoint d on a.EPID = d.EPID)
where 1 = 1
and a.Year = '2011'
ORDER BY d.EPCode, TO_NUMBER(a.ERName)) temp
where rownum <= 10)
where temp_num > 0
试下