oracle:

每月最新一条：

SELECT * FROM (select data_time,meter_id,TT_CREDIT,RE_CREDIT,DATA_STR,min(data_time) over(partition by TO_Char(data_time,'YYYY-MM')) as "atime" from WATER_DATA where 1=1
and meter_id like '%111111111111%'
) x where data_time="atime"

每月最后一条：

SELECT * FROM (select data_time,meter_id,TT_CREDIT,RE_CREDIT,DATA_STR,max(data_time) over(partition by TO_Char(data_time,'YYYY-MM')) as "atime" from WATER_DATA where 1=1
and meter_id like '%111111111111%'
) x where data_time="atime"

 

 

sql:

select FD3d0,FCreateDate,FM3m0
from (select FD3d0,FCreateDate,FM3m0 ,row_number() over (partition by FD3d0 order by FCreateDate) as rn
from TUpdateself where FCreateDate between '" + fromdate+"' and DATEADD(DAY,1,'"+fromdate+"')) t where rn<=1