PARTITION BY "分区",其实就是统计的范围条件
select t.mcno, t.mcmqno, t.hot_port
from (select r.mcno,
r.mcmqno,
r.hot_port,
r.rzdate,
row_number() over(partition by r.mcno, r.mcmqno order by r.rzdate desc) rn
from rzwh r
where r.status = 0) t
where t.rn = 1
SELECT POLICEID, policename, LONGITUDE, LATITUDE
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY POLICEID ORDER BY LOCATIONTIME DESC) rn,
BKL_POLICEDISTRIBUTION.*
FROM BKL_POLICEDISTRIBUTION
WHERE LOCATIONTIME >= SYSDATE - INTERVAL '1' HOUR)
WHERE rn = 1
SELECT POLICEID, policename, LONGITUDE, LATITUDE
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY tempTable.id ORDER BY dis asc) rn,
tttttt.*
FROM tttttt
)
WHERE rn = 1
select t.mcno, t.mcmqno, t.hot_port
from (select r.mcno,
r.mcmqno,
r.hot_port,
r.rzdate,
row_number() over(partition by r.mcno, r.mcmqno order by r.rzdate desc) rn
from rzwh r
where r.status = 0) t
where t.rn = 1
SELECT POLICEID, policename, LONGITUDE, LATITUDE
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY POLICEID ORDER BY LOCATIONTIME DESC) rn,
BKL_POLICEDISTRIBUTION.*
FROM BKL_POLICEDISTRIBUTION
WHERE LOCATIONTIME >= SYSDATE - INTERVAL '1' HOUR)
WHERE rn = 1
SELECT POLICEID, policename, LONGITUDE, LATITUDE
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY tempTable.id ORDER BY dis asc) rn,
tttttt.*
FROM tttttt
)
WHERE rn = 1