Write a query to find 2nd largest value in a table

Question

Anon · Accepted Answer

select max(value)
from table
where value < (select max(value) from table)

OR

with cte as (
select value, row_number() over (order by value desc) as rn
from table)
select * from cte where rn = 2

EY

Pergunta de entrevista da empresa EY

Resposta da entrevista

Empresas seguidas

Buscas de vagas