Frage im Vorstellungsgespräch bei AirAsia
How do you find the second highest value in a table? (SQL)
Antworten zu Vorstellungsgespräch
Anonym
22. Dez. 2018
select * from (select *,row_number() over order by colA as row from table) a where row = 2
How do you find the second highest value in a table? (SQL)
Anonym
select * from (select *,row_number() over order by colA as row from table) a where row = 2