我想在此字段自动为每个属性加个货币符号

33213321 · 发表于 2020-2-22 10:30:02

select avg(price) as 'average_price'
from titles

我想在此字段自动为每个属性加个货币符号
比如
$12.30
这个$如何加入啊?

select '$' + avg(price) as 'average_price'
from titles
不行啊

cv4bf5d65fd · 发表于 2020-5-3 10:45:02

select '$' + str(avg(price)) 'average_price'
from titles

cv4bf5d65fd · 发表于 2020-5-3 11:30:01

select '$' + rtrim(1) 'average_price'
from titles

cv4bf5d65fd · 发表于 2020-5-3 12:15:01

select '$' + rtirm(avg(price)) 'average_price'
from titles

fanfan1980 · 发表于 2020-5-3 12:45:01

--try

select '$' + rtrim(avg(price)) as 'average_price'
from titles

wgfxman · 发表于 2020-5-3 20:30:01

select '$' + RTRIM(CAST(avg(price) AS CHAR(20))) 'average_price'
from titles

		自动登录	找回密码
密码			立即注册