时间戳

首页 > 解决方案 > 如何在不更改表中列的情况下将值添加到选择列表的列开头？

sql - 如何在不更改表中列的情况下将值添加到选择列表的列开头？

问题描述

select display_value from (
    select
    FIRST_NAME || ' ' || LAST_NAME as display_value,
    case 
        when display_value is null then '<Not Assigned>' 
    end,
    UPPER(Number) as return_value,
    1 as ord
from team_members
where
    Number is not NULL
    and ANSWER = 'Y')
union all (
    select
    'Not Required' as display_value,
    'Not Required' as return_value,
    0 as ord
    from dual
) order by ord, display_value;

预期的输出应该是：

Not Assigned (if null)
Not Required
List of Names

这将用于带有保存按钮的选择列表，该按钮将根据所选值更新表格。有任何想法吗？

标签： sqloracle

解决方案

谢谢@mathguy，这是我想出的答案，它有效。

SELECT T1.display_value 
  FROM (
       (
       SELECT tm.first_name || ' ' || tm.last_name as display_value,
              UPPER(tm.number) as return_value,
              1 as ord
         FROM team_members tm
        WHERE tm.number IS NOT null
          AND tm.bool = 'Y')
 UNION ALL (
       SELECT 'Not Required' as display_value,
              'Not Required' as return_value,
              0 as ord
         FROM dual)
 ORDER BY ord, display_value) T1

该软件具有显示空值的内置功能，因此我不必首先为空值提出案例。

推荐阅读