Monday, October 28, 2013

Find Second Max in SQL

SELECT TOP 1 * From (select Top 2 * from complaint_log ORDER BY s_no DESC)a ORDER BY s_no