[ACCEPTED]-SQL select statement that shows non-existant column?-select

Accepted answer
Score: 14
select c1, c2, c3, null as c4 from table;

0

Score: 1

This would work in Oracle, haven't tried 1 in anything else:

select null thiscolumnisempty, id,id2,id3 from table
Score: 1

select c1, c2, c3, '' as c4 from table; select 3 c1, c2, c3, 0 as c4 from table; if you want 2 int then take 0 or if you want varchar then 1 take ''.

More Related questions