[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 ''.

Source: stackoverflow.com

More Related questions

Informix: Select null problem

MySQL IN with LIKE

How to get running sum of a column in sql server

Update Table with a "Select query" with a where clause

What is better? Subqueries or inner joining ten tables?

Select all if parameter is null in stored procedure

Avoid printing table name in column name while using beeline

Why postgres returns unordered data in select query, after updation of row?

Select the first 3 rows of each table in a database

SQL SUM values where 2 conditions are met

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.