Explore BrainMass

Writing query for SQL using NESTED-SELECT statement

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

Solution Summary

The expert writes a query for SQL using NESTED-SELECT statements.