Lucia Folle
Last answered:

17 Mar 2023

 Posted on:

17 Mar 2023
1

thousands separator

in SQL / ROUND()

hi, 

how can SQL show numbers with thousand separator, for example: 63,761.20 instead of 63761.20?


Thank you


Luica

1 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

17 Mar 2023
2

Hi Lucia!
Thanks for reaching out.

You can use something like this:

SELECT FORMAT(12332.123456, 4);
->  '12,332.1235'


Hope this helps.
Best,
Tsvetelin

Submit an answer