how to find second largest number in column

Answer 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 )

Answer 2

SELECT *
FROM TableName a
Where
2 = (SELECT count(DISTINCT(b.ColumnName))
FROM TableName b WHERE
a.ColumnName <= b.ColumnName);