Re: Advanced SQL statements writing

From: Serge Rielau <>
Date: Sat, 18 Apr 2009 10:15:07 +0200
Message-ID: <>

Phper wrote:
> How can I achieve this?

The purpose of the SELECT list is to select out the columns. So instead of using * just pick what you need. In order to pick columns from subqueries they need to be named. E.g. SELECT c FROM (SELECT (a + b) AS c FROM T)


Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Received on Sat Apr 18 2009 - 03:15:07 CDT

Original text of this message