I have a list of incomes (in column labeled Income) in a table labeled Jobs. I need to find the second highest number in the income column. I know that the MAX function finds the highest, but how would I find the second highest income using a NESTED-SELECT statement???© BrainMass Inc. brainmass.com March 21, 2019, 7:16 pm ad1c9bdddf
The expert writes a query for SQL using NESTED-SELECT statements.