0
how to find second largest number in column
2 Réponses
+ 1
I believe that with this command is possible:
Selec max(name-column)
from your-table
where name-column !=
(select Max(name-column) from your-table )
+ 1
SELECT *
FROM TableName a
Where
2 = (SELECT count(DISTINCT(b.ColumnName))
FROM TableName b WHERE
a.ColumnName <= b.ColumnName);