Barclays Interview Question: Write a query to find the second-highest salary in a table. | Glassdoor

Skip to content Skip to footer

Notifications

Loading...

employer cover photo

Barclays

Barclays Data Engineer interview

Barclays Interview Question

Data Engineer Interview

Write a query to find the second-highest salary in a table.

Interview Answer

Anonymous

Sep 24, 2024

SELECT MAX(salary) AS second_highest_salary FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);

Related searches: Barclays reviews | Barclays jobs | Barclays salaries | Barclays benefits | Barclays conversations

Barclays interviews