-
溃烂模样
发布于 2022-06-28 09:08
-
收藏
按年查询select to_char(date::DATE, 'YYYY') as year,sum(shares) as shares, sum(visits) as visits from database_tablewhere date >= '2019-01-01' anddate <= '2020-01-01'group by year order by year按月查询select to_char(date::DATE, 'YY..