17,140
社区成员




select t.dz , t.time , max(date) date from tb t where dz = '北京' group by t.dz , t.time
--如果你的time , data是两个字段
select t.dz , t.time , max(date) date from tb t where dz = '北京' group by t.dz , t.time
--如果你的time,data是一个字段,假设是time
select t.dz , max(time) time from tb t where dz = '北京' group by t.dz , to_char(t.time,'YYYY-MM-DD')
SELECT dz, time, data
FROM (SELECT dz,
time,
data,
ROW_NUMBER ()
OVER (PARTITION BY dz, TRUNC (time, 'dd')
ORDER BY time DESC)
rn
FROM table_name)
WHERE rn = 1
ORDER BY dz, time --不需要就去掉