PG常用语法笔记

日期分组统计

SELECT
	to_char( create_time, 'YYYY-MM-DD' ) AS createTime,
	COUNT ( ID ) AS total_count 
FROM
	cardata_user_temp 
WHERE
	create_time >= '2020-02-01 00:00:00' 
GROUP BY
	createTime

窗口函数

    select id,name,age,salary,row_number()over(partition by id order by salary desc) rank
    from TEST_ROW_NUMBER_OVER t