17,377
社区成员
发帖
与我相关
我的任务
分享
select
(SELECT 'Loroe' FROM DUAL ) 团长,
(SELECT 'Dance' FROM DUAL ) 连长,
(SELECT 'Nanlar' from DUAL ) 排长
SELECT MAX(DECODE(LEV, '团长', USERNAME)) 团长,
MAX(DECODE(LEV, '连长', USERNAME)) 连长,
MAX(DECODE(LEV, '排长', USERNAME)) 排长
FROM (SELECT 'Loroe' USERNAME, '团长' LEV
FROM DUAL
UNION ALL
SELECT 'Dance' USERNAME, '连长' LEV
FROM DUAL
UNION ALL
SELECT 'Nanlar' USERNAME, '排长' LEV FROM DUAL);