add a temporary column with a value

Question

I have a select statement like this

select field1, field2  
  from table1

What I want is to have a newfield with only value "example".

newfield does not exist in the table, but when I run this query it kinda makes a virtual column with the values of example field.

Answer 1

select field1, field2, 'example' as TempField
from table1

This should work across different SQL implementations.

Answer 2

You mean staticly define a value, like this:

SELECT field1, 
       field2,
       'example' AS newfield
  FROM TABLE1

This will add a column called "newfield" to the output, and its value will always be "example".

Answer 3

I'm rusty on SQL but I think you could use select as to make your own temporary query columns.

select field1, field2, 'example' as newfield from table1

That would only exist in your query results, of course. You're not actually modifying the table.

Answer 4

select field1, field2, NewField = 'example' from table1