-
PostgreSQL实现按年、月、日、周、时、分、秒的分组统计
按年查询select to_char(date::DATE, 'YYYY') as year,sum(shares) as shares, sum(visits) as visits from database_ta
-
oracle实现按天,周,月,季度,年查询排序方法
oracle按天,周,月,季度,年查询排序天--to_char(t.start_time,'YYYY-MM-DD')周 --to_char(t.start_time,'YYYY'),to_char(