如图求出数据中最大值

1是最高优先 如果1是相同就求2是最大的
查询出来结果 只能有蓝色选择区域一条

SELECT * FROM E;

SELECT A, B
FROM (SELECT A., RANK() OVER(ORDER BY B DESC) C FROM E A)
WHERE C = 1
AND A =
(SELECT MAX(A)
FROM (SELECT A, B
FROM (SELECT A., RANK() OVER(ORDER BY B DESC) C FROM E A)
WHERE C = 1));

select
p.*
from
(select a.* from table a order by a.bubbmitpmax desc,a.subbmitmax desc) p
where
rownum = 1
;