Below is shown the "Orders" table:
D001 |
C001 |
4/3/2007 12:00:00 AM |
150.23 |
D002 |
C003 |
1/22/2005 12:00:00 AM |
123.57 |
D003 |
C005 |
3/19/2003 12:00:00 AM |
220.43 |
D004 |
C007 |
7/21/2008 12:00:00 AM |
157.72 |
D005 |
C008 |
2/28/2009 12:00:00 AM |
223.78 |
D006 |
C011 |
3/21/2005 12:00:00 AM |
245.34 |
SQL - SECOND Largest value
To retrieve the SECOND Largest value from the Amount Column in the "Orders" Table, it is done by using SQL SUBQUERY.
Text Editor below has the SQL Query, click the "View Result" button, to see the result.
Select MAX(Amount) as SecondLargest From Orders
Where Amount < (Select MAX(Amount) From Orders);
Note: In the Subquery the Maximum value is fetched and it is used by the main query to get the second Maximum value of the Amount Column.
SQL in Text Editor: