select * from (select max(datadate) as datadate from monitor_data where datadate>= ‘2020-01-01’ and datadate<=‘2020-09-13’ GROUP BY to_char(datadate, ‘yyyy-mm’) ) t ORDER BY t.datadate desc
sql查询每个月最大日期
最新推荐文章于 2023-02-01 17:21:30 发布
select * from (select max(datadate) as datadate from monitor_data where datadate>= ‘2020-01-01’ and datadate<=‘2020-09-13’ GROUP BY to_char(datadate, ‘yyyy-mm’) ) t ORDER BY t.datadate desc