In many technical interviews, many of you face the same question as I did. After a long search and try I find out the exact query

It is just like this:

SELECT * FROM <tablename> ORDER BY <fieldname> desc limit <n-1>, 1;

Just check it with your table and comment your findings.