CODE EXAMPLE FOR SQL

2 max value in sql

SELECT MAX (column_name) 
FROM table_name 
WHERE column_name NOT IN (SELECT Max (column_name) 
                          FROM table_name);