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]
只要求显示一行.
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