SQL 语句列转行的一个问题? 大家帮忙看下.?

Question

select ES_BTRIPCOSTITEM.amount from ES_BTRIPCOSTITEM ES_BTRIPCOSTITEM
where ES_BTRIPCOSTITEM.application_id=206;

我用的是Oracle数据库....

这条sql语句的查询结果如下：
AMOUNT

23

11

22

56

我想要一条Sql语句,转换成这种格式输出:
[color=blue]
AMOUNT1 AMOUNT2 AMOUNT3 AMOUNT4
23 11 22 56
[/color]
只要求显示一行.

Answer 1

select sum(decode(amount, 23, 23, null)) amount1,
sum(decode(amount, 11, 11, null)) amount2,
sum(decode(amount, 22, 22, null)) amount3,
sum(decode(amount, 56, 56, null)) amount4
from test