美元符号、逗号、小数位数

Question

我有这段代码来获取total和其他字段。我感兴趣的是什么要获得带有$符号、逗号和02位小数的总值用来覆盖所有这些的最佳函数。所以总额应该反映为：1780.00美元

请告知

select distinct
c.givenname, c.familyname, s.total, p.title,
a.givenname+' '+a.familyname as artist
from
customers as c
join sales as s on c.id=s.customerid
join saleitems as si on s.id=si.saleid  
join paintings as p on si.paintingid=p.id   
join artists as a on p.artistid=a.id;

---

我得到的结果是这样的：

Aloysius Peace  1780.0000 Woman in Black (Femme en noir)Mary Cassatt
Amanda  Lynn    1115.0000 Le Moulin de la Galette   Pierre-Auguste Renoir
Amanda  Lynn    1115.0000 Madamoiselle RiviereJean-Auguste-Dominique Ingres
Amanda  Lynn    1115.0000 Pollard Willows With SETting SunVincent Van Gogh
Amelia  Rate    2125.0000 Flowers in a Vase with Shells and InseBalthasar Van 
Amelia  Rate    2125.0000 The Meeting of St Anthony Abbot and St Paul in the 
Amelia  Rate    2125.0000 The Two Girlfriends   Henri de Toulouse-Lautrec
Amelia  Rate    2125.0000 Vision After the Sermon, Jacob Wrestling  

Answer 1

在代码中使用类似的方法。(用于MS SQL(

select '$' + cast(cast (s.total as decimal (9,2)) as varchar(20)) as price