Query Second Largest Salary in SqlServer2005

1)First Query for getting the N largest salary (where N=2)

SELECT max(CURRENT_NEWS_ID)
FROM (SELECT TOP N CURRENT_NEWS_ID FROM CURRENT_NEWS order by CURRENT_NEWS_ID ASC)a
//WHERE N=3

2)Second query for second largest salary

SELECT TOP 1 CURRENT_NEWS_ID FROM
(

SELECT TOP 2 CURRENT_NEWS_ID FROM (SELECT CURRENT_NEWS_ID FROM CURRENT_NEWS )A ORDER BY CURRENT_NEWS_ID DESC
)T ORDER BY CURRENT_NEWS_ID ASC