Select where column result = all ?

asp_crazy_guy · #1 (**permalink**) 07-07-09, 00:07

Hi,
I have a situation where I have to make a report on basis of some parameters. The report should be able to display certain or all columns on basis of a single query.

There query can be

select * from table1 where column1='somevalue'

or

select * from table1 where column1=* ? --- (all values in that column)

How can I select all column values by the where clause ?

Can this be done in DB2 with a single query without the need to use if else statements and 2 separate queries ?

Best regards,
Mike.

tonkuma · #2 (**permalink**) 07-07-09, 00:48

Quote:

select * from table1 where column1='somevalue'

or

select * from table1 where column1=* ? --- (all values in that column)

To choose first or second query, this may give equivalent results.
(The row which column1 is null would not be selected.)

Code:

select *
  from table1
 where column1 = CASE
                 WHEN <condition to select somevalue> THEN
                      'somevalue'
                 ELSE column1
                 END
;