将带有千位分隔符的值插入表中

Michi 发表于 Dev

道

我使用以下 SQL 创建一个包含值的表：

CREATE TABLE Logistics (
    country TEXT,
    Costs_Inbound CHAR(255),
    Costs_Storage CHAR(255),
    Costs_Outbound DECIMAL(65,3)

);


INSERT INTO Logistics 
(country, Costs_Inbound, Costs_Storage, Costs_Outbound)
VALUES 
("DE", "5000", "300", "600500.815"),
("NL", "3000", "650", "250452.454"), 
("FR", "4000", "120", "750060.932");

和以下 SQL 来查询表中的值：

SELECT country, sum(Costs_Inbound), sum(Costs_Storage), sum(Costs_Outbound),
       (sum(Costs_Inbound) + sum(Costs_Storage) + sum(Costs_Outbound)) as Total
FROM Logistics
GROUP BY country WITH ROLLUP;

您还可以在sqlfiddle 此处找到代码。
到目前为止，所有这些都运行良好。

现在，我希望这些值以千位分隔符进入表格，而不是6000500,815,250452.454并且750060.932它们应该显示为600,500.815,250,452.454和750,060.932。

你知道我如何实现这一目标吗？

宰努尔·阿巴丁·图欣

使用format功能

SELECT country, FORMAT (sum(Costs_Inbound),2) Costs_Inbound, 
FORMAT(sum(Costs_Storage),2) Costs_Storage,
FORMAT(sum(Costs_Outbound), 2) Costs_Outbound,
      FORMAT( (sum(Costs_Inbound) + sum(Costs_Storage) + sum(Costs_Outbound)),2) as Total
FROM Logistics
GROUP BY country WITH ROLLUP

http://sqlfiddle.com/#!9/92d35b2/7

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。