如何在从数据库中选择值时以格式显示数字（1234->为1,234）

Question

How to display numbers with format(1234->as 1,234) while selecting values from database

SELECT rates,invoice FROM data;

Now Rates are displaying as 235693 like this,but i want display it as 2,35,693.

Answer 1

use format function

SELECT FORMAT(235693,0);