CODEWITHSUNDEEP
sqldb2ibm-midrange
jallen3095
jallen3095

Reputation: 65

DB2 SQL Select All With Columns As

I am working with some SQL queries on DB2. Is it possible to select all the columns in a table and also specify certain conditions using the "as" keyword within that select statement? For example, is this query possible:

select
  *,
  col1 + col2 as sum1,
  col3 - col4 as dif1
from 
  table;

Whenever I attempt this, I am getting the SQL0104 error and it is saying "Token , was not valid. Valid tokens: FROM INTO".

Thank you for your help.

EDIT: This query is running inside an SQLRPGLE program on an AS400.

Upvotes: 3

Views: 9846

Answers (1)

JoeWilson
JoeWilson

Reputation: 166

Put your table alias in front of the *. So: 

select
  t.*,
  col1 + col2 as sum1,
  col3 - col4 as dif1
from 
  table t;

Upvotes: 10

Related Questions