KRISHNA

Sql: To find the 2nd largest row

SELECT add_idx
FROM address_check C1
WHERE 2 = (
SELECT count( * )
FROM address_check C2
WHERE
C1.add_idx <= C2.add_idx )

or

SELECT * FROM TABLE
WHERE columnName =
(SELECT max( SELECT MAX(columnName) FROM TABLE WHERE columnname<(columnname) FROM TABLE))

Liu Huan & Sarah Brightman - You and Me, 2008 Beijing Olympics Official Theme Song