Return null row on select sql

Question

I know this might seem a bit strange but I want to build a stored procedure that returns some values but I want the first row to be a null value. What I have for the query and returns are

SELECT CONCAT(id, '   ', item)As DisplayBox, id, item FROM table
DisplayBox  id  expense
1   Value2  1   Value2
2   Value3  2   Value3
3   Value4  3   Value4
4   Value5  4   Value5

But I am interested in having a result like

DisplayBox  id  Item
<BlankText> Null <BlankText>
1   Value2  1   Value2
2   Value3  2   Value3
3   Value4  3   Value4
4   Value5  4   Value5

Kermit · Accepted Answer · 2013-07-24 18:28:41Z

2

You can use UNION ALL:

SELECT NULL AS DisplayBox, NULL AS id, NULL AS item
UNION ALL
SELECT CONCAT(id, '   ', item)As DisplayBox, id, item FROM table

answered Jul 24, 2013 at 18:28

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

koljaTM · Accepted Answer · 2013-07-24 18:30:22Z

1

SELECT null as displaybox, null as id, null as item from dual
union all
SELECT CONCAT(id, '   ', item)As DisplayBox, id, item FROM table
order by (case when id is null then 0 else 1 end)

answered Jul 24, 2013 at 18:30

koljaTM

10.3k2 gold badges42 silver badges42 bronze badges

Collectives™ on Stack Overflow

Return null row on select sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related