我有以下 SQL Server 查詢：
select max(AveragePrice) as [LARGEST AVERAGE]
from
(select b.brand_id, round(avg(prod_price),2) as AveragePrice
from lgbrand b, lgproduct p
where b.brand_id = p.brand_id
group by b.brand_id) x
輸出
LARGEST AVERAGE
22.590000
如何修剪小數以僅顯示“22.59”？
uj5u.com熱心網友回復：
用于ROUND向上或向下舍入到指定的小數位數。
select round(max(AveragePrice),2) as [LARGEST AVERAGE]
from
(select b.brand_id, round(avg(prod_price),2) as AveragePrice
from lgbrand b, lgproduct p
where b.brand_id = p.brand_id
group by b.brand_id) x
uj5u.com熱心網友回復：
您可以使用該功能FORMAT：
SELECT FORMAT(MAX(averageprice),'#0.00') AS largest_average,...
uj5u.com熱心網友回復：
您可以嘗試以下方法將其轉換為小數點后 2 位。
declare @table table(val decimal(8,6))
insert into @table
values (22.590000)
select Format(val,'##.##') from @table
SELECT cast(val as decimal(4,2)) from @table
SELECT convert(decimal(4,2), val) from @table
22.59
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/486982.html
上一篇：添加列的案例陳述句
下一篇：讓用戶在日期前30天（含）注冊