Subject | CASE / PIVOT / CROSSTAB |
---|---|
Author | donjules2k |
Post date | 2004-05-20T09:46:46Z |
Can firebird return a pivot or crosstab table?
Does it support using case or if statements in field names?
such as:
select (case field1
when 'hello' then field2
else field3),
field4,
field5
from mytable
OR
select (if field1 = 'hello' then
field2
else
field3),
field4,
field5
from mytable
Thanks
Giulio
Does it support using case or if statements in field names?
such as:
select (case field1
when 'hello' then field2
else field3),
field4,
field5
from mytable
OR
select (if field1 = 'hello' then
field2
else
field3),
field4,
field5
from mytable
Thanks
Giulio