ASP.NET with C# and SQL SERVER , some vb.net .
asp.net examples, asp.net codes, asp.net programs, c# code, sql server queries, important codes.
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