sql相关

千位分隔符

pgsql

SELECT TO_CHAR(76543210.98, '999G999G999G999G999G999G990D')

索引号

pgsql

ROW_NUMBER() OVER (PARTITION BY al_province_id ORDER BY al_rank) AS id

case when

pgsql

CASE 
     WHEN is_npc = 1 THEN 'npc'
     ELSE '非npc'
 END   

时间格式

pgsql

DATE_FORMAT(net_test_time,'%Y-%m-%d %H:%i') as net_test_time