WITH T AS(
SELECT '第一'
NAME ,'2052' CULTURE FROM DUAL
UNION
SELECT 'FIRST'
NAME ,'1033' CULTURE FROM DUAL)SELECT MAX(Z.CN_NAME) CN_NAME,MAX(Z.EN_NAME) EN_NAMEFROM(
SELECT DECODE(NAME,'第一','第一',NULL ) AS CN_NAME
,DECODE(NAME,'FIRST','FIRST',NULL ) AS EN_NAME
FROM T
GROUP BY NAME,CULTURE
ORDER BY 1,2)Z;复制代码
|