日本免费高清视频-国产福利视频导航-黄色在线播放国产-天天操天天操天天操天天操|www.shdianci.com

學無先后，達者為師

網站首頁 編程語言 正文

PostgreSQL實現按年、月、日、周、時、分、秒的分組統計_PostgreSQL

作者：小旭2021 ? 更新時間： 2022-08-20 編程語言

按年查詢

select to_char(date::DATE, 'YYYY') as year,sum(shares) as shares, sum(visits) as visits 
from database_table
where date >= '2019-01-01' and  date <= '2020-01-01'  group by year order by year

按月查詢

select to_char(date::DATE, 'YYYY-MM') as month,sum(shares) as shares, sum(visits) as visits 
from database_table
where date >= '2019-01-01' and  date <= '2020-01-01'  group by month order by month

按周查詢

select to_char(date::DATE-(extract(dow from date::TIMESTAMP)-1||'day')::interval, 'YYYY-mm-dd') week,
sum(shares) as shares, sum(visits) as visits 
from database_table 
where date >= '2019-01-01' and  date <= '2020-01-01' group by week order by week

按天查詢

select to_char(date::DATE, 'YYYY-MM-DD') as day,sum(shares) as shares, sum(visits) as visits 
from database_table
where date >= '2019-01-01' and  date <= '2020-01-01'  group by day order by day

按小時查詢

select to_char(date::DATE, 'YYYY-MM-DD  HH24') as hour,sum(shares) as shares, sum(visits) as visits 
from database_table
where date >= '2019-01-01' and  date <= '2020-01-01'  group by hour order by hour

按分鐘查詢

select to_char(date::DATE, 'YYYY-MM-DD  HH24:MI ') as minute,sum(shares) as shares, sum(visits) as visits 
from database_table
where date >= '2019-01-01' and  date <= '2020-01-01'  group by minute order by minute

按秒查詢

select to_char(date::DATE, 'YYYY-MM-DD  HH24:MI:SS ') as second,sum(shares) as shares, sum(visits) as visits 
from database_table
where date >= '2019-01-01' and  date <= '2020-01-01'  group by second order by second

原文鏈接：https://www.cnblogs.com/chenyablog/p/12482855.html

欄目分類
最近更新