oracle中多个case语句的别名

Question

我是这个甲骨文概念的新手，谁能帮我为案例陈述取个别名呢？

select * from (
    Select CASE WHEN to_char(honor) = 1 then 'FIRST'
              WHEN to_char(honor) = 2 then 'SECOND'
              WHEN to_char(honor) = 3 then 'THIRD'
              WHEN to_char(honor) = 4 then 'FOURTH'
              ELSE to_char(honor) END as temp ,HORONABLE,to_char(crtd_dtt,'YYYY-MM') as "DateofHonor"
     from ld_leg_t
     where CUR_OPTLSTAT_ID not in (355,360)
     ORDER BY  to_char(crtd_dtt,'YYYY-MM') ASC )
    pivot
    (
    count(HORONABLE)
    for temp in ('FIRST','SECOND','THIRD','FOURTH')
    )
order by "DateofHonor"

有什么办法可以包括别名的第一，第二，第三和第四。这样我就可以使用PHP检索它。

Answer 1

如果你是这个意思，那么是的-看看FOR TEMP ...行和正在使用的别名。

SQL> SELECT *
  2    FROM (SELECT CASE
  3                    WHEN deptno = 10 THEN 'FIRST'
  4                    WHEN deptno = 20 THEN 'SECOND'
  5                    WHEN deptno = 30 THEN 'FOURTH'
  6                    ELSE '40'
  7                 END AS temp,
  8                 dname
  9            FROM dept)
 10         PIVOT (COUNT (dname) FOR temp IN ('FIRST' as A, 'SECOND' as B, 'THIRD' as C));

         A          B          C
---------- ---------- ----------
         1          1          0

SQL>