type = 0条件放到外层,另外看你存在时间相同的记录 order里最好增加 id desc 排序 SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY z.code ORDER BY z.time DESC,ID DESC) AS rnxx, z.* FROM A1 z) WHERE rnxx = 1 and type = 0
select * from A1 a ,(select b.code,max(b.time) time from A1 b group by code) c where a.code = c.code and a.time=c.time and type=0
SELECT *
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY z.code ORDER BY z.time DESC,ID DESC) AS rnxx,
z.*
FROM A1 z)
WHERE rnxx = 1 and type = 0
where a.code = c.code and a.time=c.time and type=0