Write a sql query to find the second largest number from table table_name and column number.

 Write a sql query to find the second largest number from table table_name and column number.

select *
from (select Rownum as SLNO
           from(select col_name
                    from tablename
                    order by desc ))
where SLNO =2;