Вопрос на засыпку

[abc]

Вот что нашел на интернете:

SELECT * FROM table_name WHERE column_name IN (SELECT MAX(column_name) FROM table_name WHERE column_name <> (SELECT MAX(column_name) FROM table_name))