Domanda di colloquio di Enova

I was asked questions in SQL about finding the second highest value in a column.

Risposta di colloquio

Anonimo

9 feb 2017

There are multiple ways of doing it. One easy way is: Order by Col_name Desc, Limit 1 ,1 ;