FORMAT_NUMBER

描述

返回一个使用单位符号格式化的字符串。具体单位有: "K", "M", "B", "T", "Q"

语法

FORMAT_NUMBER(<val>)

参数

参数	说明
<val>	需要被格式化带单位的数值

返回值

参数 val 的带单位符号格式化的字符串

举例

SELECT format_number(123456.0);

+-----------------------------------------+
| format_number(cast(123456.0 as DOUBLE)) |
+-----------------------------------------+
| 123K                                    |
+-----------------------------------------+

SELECT format_number(1000000.00);

+-------------------------------------------+
| format_number(cast(1000000.00 as DOUBLE)) |
+-------------------------------------------+
| 1M                                        |
+-------------------------------------------+

select format_number(-1000000000000000);

+--------------------------------------------------+
| format_number(cast(-1000000000000000 as DOUBLE)) |
+--------------------------------------------------+
| -1Q                                              |
+--------------------------------------------------+