在oracle中查询数据答:dual;INSERT INTO temp_005 SELECT 5,6,5 from dual;INSERT INTO temp_005 SELECT 5,7,4 from dual;执行查询的SQL select a, b, c from (select t.a, t.b, t.c, row_number() over(partition by a order by b) d from temp_005 t order by c desc, a asc)where d = 1;...