Share
Affine Analytics Interview Questions | How to get 3 Min salaries?
Question
TheDataMonk
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Answers ( 3 )
select distinct(salary) from salary_details order by salary asc limit 3
SELECT DISTINCT salary
FROM employees a
WHERE 3 >= (SELECT COUNT(DISTINCT salary)
FROM employees b
WHERE b.salary <= a.salary)
ORDER BY a.salary DESC;
select DISTINCT (salary)
from Table
ORDER BY salary ASC
LIMIT 3;