摘要:
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')) a 阅读全文
摘要:
select top 5 * from Messages where MessageId not in(select top (5*2) MessageId
from Messages order by MessageDate desc) order by MessageDate desc 阅读全文