我这边有个一个语句,在sql环境下运行没的问题,现在要在Orcle环境下运行,不知道该条语句是否可运行起。请大家建字段,帮我运行一下,在此先谢谢大家咯。
SELECT TOP 8 * FROM( select ROW_NUMBER() OVER(ORDER BY OBU_Name desc)AS RowNumber,* from (select Eng_Name,
(case When OBU_Name='DHQ' or OBU_Name='DTW' then replace(OBU_Name,'D','') else OBU_Name End)
as OBU_Name,Email,(case When OBU_Name='DHQ' or OBU_Name='DTW' then replace(Img_Path,'.jpg','')
else Email end) as GLOBAL_EMPNO,FUNCTION_NAME,TITLE_NAME,TEL From V_GLOBAL_MEMBER_LIST_EMPNO
WHERE (STATUS = 'A' ))tmpTable where 1=1 ) B WHERE RowNumber > 0
SELECT TOP 8 * FROM( select ROW_NUMBER() OVER(ORDER BY OBU_Name desc)AS RowNumber,* from (select Eng_Name,
(case When OBU_Name='DHQ' or OBU_Name='DTW' then replace(OBU_Name,'D','') else OBU_Name End)
as OBU_Name,Email,(case When OBU_Name='DHQ' or OBU_Name='DTW' then replace(Img_Path,'.jpg','')
else Email end) as GLOBAL_EMPNO,FUNCTION_NAME,TITLE_NAME,TEL From V_GLOBAL_MEMBER_LIST_EMPNO
WHERE (STATUS = 'A' ))tmpTable where 1=1 ) B WHERE RowNumber > 0
解决方案 »
- Oracle内存中的块过滤情况?
- 跨ORACLE 数据库连接SQL SERVER,读取SQL SERVER CHAR,VARCHAR型数据被截串
- 回车符问题
- 请教两个oracle问题
- 如何连接两个字段?
- 紧急求救:ORA-00093: shared_pool_reserved_size must be between 5000 and 8388608错误
- 如何优化该SQL语句???
- 如何在oracle数据库中,增加一个“数值自动增长”的字段?
- 讨论:在oracle中大量数据(100万以上)量查询或修改时,有那些办法可以提高操作速度?
- in与exists 的问题。。。
- 请问各位大侠:ORACLE数据库中求除数字、字母之外的非中文字符的正则表达式
- oracle自增列问题 求高手解答
SELECT *
FROM (select ROW_NUMBER() OVER(ORDER BY OBU_Name desc) AS RowNumber,tmpTable.*
from (select Eng_Name,
(case
When OBU_Name = 'DHQ' or OBU_Name = 'DTW' then
replace(OBU_Name, 'D', '')
else
OBU_Name
End) as OBU_Name,
Email,
(case
When OBU_Name = 'DHQ' or OBU_Name = 'DTW' then
replace(Img_Path, '.jpg', '')
else
Email
end) as GLOBAL_EMPNO,
FUNCTION_NAME,
TITLE_NAME,
TEL
From V_GLOBAL_MEMBER_LIST_EMPNO
WHERE (STATUS = 'A')) tmpTable
where 1 = 1) B
WHERE RowNumber > 0 and rownum<=8