SELECT Min (emp_sal)
FROM employee
WHERE emp_sal IN (SELECT DISTINCT TOP n emp_sal
FROM employee
ORDER BY emp_sal DESC)
FROM employee
WHERE emp_sal IN (SELECT DISTINCT TOP n emp_sal
FROM employee
ORDER BY emp_sal DESC)
This blog provides some ready-made tips, tricks, tweaks & interview questions-answers on C, C++, Perl, Shell Scripting and UNIX Commands.
No comments :
Post a Comment