如图求出数据中最大值

Question

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

Answer 1

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));