在sqlite中返回的列中添加货币符号

Question

我需要添加一个货币符号。我做了什么：

select department,round(sum(total),0) ||"€"  as n from members 
          group by department 

它给出了：

     department         n
1       a      5451077.0<U+0080>
2       b      3540614.0<U+0080>
3       c      4343046.0<U+0080>
4       d      332388.0<U+0080>
5       e      116737.0<U+0080>

Answer 1

您可以尝试这个

select department,(round(sum(total),0) ||'€')  as n from members 
          group by department