Saturday, 22 February 2014

Find Second Max in SQL

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   

No comments:

Post a Comment