Fresher (0–1 years) Coding / DSA Easy

Write a SQL query to find the second highest salary from an Employee table

Q: Write a SQL query to find the second highest salary from an Employee table

SELECT MAX(salary) AS second_highest FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);Alternatives: DENSE_RANK() OVER (ORDER BY salary DESC) and filter rank = 2; or OFFSET 1 LIMIT 1 on distinct salaries (DB-specific).Mention NULL when fewer than two distinct salaries exist.

Standard SQL screening question for 0–1 year candidates.

Role: Ninja / Digital profile
Location: Chennai
Study track: SQL

Spoiler-free prep mode

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

Alternatives: DENSE_RANK() OVER (ORDER BY salary DESC) and filter rank = 2; or OFFSET 1 LIMIT 1 on distinct salaries (DB-specific).

Mention NULL when fewer than two distinct salaries exist.

Discussion

Comments (0)

Share how this question came up in your loop, or add tips for others preparing.

Try answering aloud first

Comments (0)