Exercise 4
Explore how to write nested SQL queries to retrieve the second-highest salary from a salary table. This lesson guides you through querying techniques with nested subqueries, helping you practice practical SQL skills for data retrieval tasks involving employee salaries.
We'll cover the following...
We'll cover the following...
Problem statement
Write a SQL query to fetch the second-highest salary in the SALARY table.
HINT: You will need to nest one query inside another to solve this problem.
Input
The following tables are available to you as inputs:
EMPLOYEE Table ...
SALARY Table