Finding Second Max in a table
We can get the second max from a table using many ways
one of the easiest way is using sub-query, ie by finding the max and then
the value less than max
SELECT id FROM user WHERE uid< (SELECT MAX(id) FROM user) limit 0,1;
The sub-query will return max uid and then the main query checks for uid less
than that.
