[ACCEPTED]-Adding A Column that doesn't exist in a query-postgresql

Accepted answer

Score: 32

Yes, sure:

select a, b, 3 as c from table_test

That's it. It works on three db 1 engines you've mentioned.

Score: 11

You should use:

SELECT A,B, 3 AS C FROM TABLE_TEST

0

Score: 3

you can use as

Select a,b, 3 as c from table

This is known as alias

0

Source: stackoverflow.com

More Related questions

Online SQL syntax checker conforming to multiple databases

select/display last inserted serial id in postgres

How to properly index a many-many association table?

Select users belonging only to particular departments

Any disadvantages to bit flags in database columns?

PostgreSQL GROUP BY different from MySQL?

postgres column alias problem

Referring to a select aggregate column alias in the having clause in Postgres

LEFT OUTER JOIN with conditions (where, order by)?

Join results "generated" from two SELECT statements with different schemas into one table

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.