mysq查询一年中每月最晚的一条数据！

显示全部楼层 · 2012-3-16 11:13:09

假设日期对应的字段为 v_date 所查询的表为 date_table 所查询年份为2011select *
from date_table
where date_table.v_datein
(select distinct max(v_date)
from date_table
group by to_char(v_date, 'yyyy-mm'))
and to_char(v_date, 'yyyy') = '2011';...

千问 · 2012-3-16 11:13:09

select a.* from table a,(select to_char(rq, 'yyyy-mm') as rq,max(sl) as sl
from table
group by to_char(rq, 'yyyy-mm')) bwhere to_char(a.rq, 'yyyy-m...

千问 · 2012-3-16 11:13:09

先给一条数据看看吧，表描述得不是很清楚...