Saturday, 20 October 2012

get second maximum value in sql query




Find Out Second Maximum


SELECT     MIN(CapitalAccountID) AS ID
FROM         bal_CapitalAccount
WHERE     (CapitalAccountID IN
                          (SELECT     TOP (3) CapitalAccountID
                            FROM          bal_CapitalAccount AS bal_CapitalAccount_1
                            ORDER BY CapitalAccountID DESC))

No comments:

Post a Comment