You need to find the second-highest salary in a table without using TOP/LIMIT. Which approach works in standard SQL?

SQL Data Analyst Hard

SQL Data Analyst — Hard

You need to find the second-highest salary in a table without using TOP/LIMIT. Which approach works in standard SQL?

Key points

  • Comparing salaries with the highest value is a key concept here.
  • Using a subquery to find the maximum salary is crucial.
  • Avoiding the use of TOP/LIMIT is a requirement for this question.

Ready to go further?

Start full exam Practice more questions

Related questions