sql - 将数字格式化为货币金额

Question

我想为我的 SQL 披萨餐厅数据库创建一个“销售报告”。当我尝试使用 sum(order_amount) 运行 SELECT 查询时，该列未格式化。我正在使用 Oracle SQL。这是代码:

column order_amount heading "Order Amount" format '$9,999,999.00';
select order_id, count(order_id) as "Number of Orders", sum(pizza_quantity) as "Pizzas Sold", 
sum(order_amount) as "Total Profit"
from order_details group by order_id;

这是输出:

SQL> select order_id, count(order_id) as "Number of Orders",sum(pizza_quantity) as "Pizzas Sold",
  2  sum(order_amount) as "Total Profit"
  3  from order_details group by order_id;

  Order ID Number of Orders Pizzas Sold Total Profit
---------- ---------------- ----------- ------------
         1                2           5          105
         6                1           2           20
         2                2           6          165
         4                2          12          130
         5                2           6           80
         8                1           7          140
         3                2           4           80
         7                1           6          120
         9                1           8          120
        10                1           9          270

10 rows selected.

有什么方法可以显示格式化为货币的总利润列吗？

Answer 1

您可以尝试使用 to_char()。

...
to_char(sum(order_amount), '$9,999,999.00')
...