Question d’entretien chez AirAsia

How do you find the second highest value in a table? (SQL)

Réponses aux questions d'entretien

Utilisateur anonyme

22 déc. 2018

select * from (select *,row_number() over order by colA as row from table) a where row = 2

Utilisateur anonyme

5 avr. 2017

They replied you 1.5 months after interview?

5