Create a query to find the second highest income-salary


Discussion:

Q: Create a query to find the second highest income/salary.

Table: Income
Emp_id Emp_name Dept Salary
1 Anthony Gonzales Finance 100,000
2 Timothy Dalton IT 94,000
3 Maria D'souza Msci 79,000
4 Monica Lee Clent Services 150,000
5 Umesh Shah Engg 125,000
6 John Reginald AppDev 73,000

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Create a query to find the second highest income-salary
Reference No:- TGS01938965

Now Priced at $25 (50% Discount)

Recommended (93%)

Rated (4.5/5)