how to select 3rd highest or nth highest salary from the employee table.

86 views
Skip to first unread message

Gurumukh Gupta

unread,
Jul 13, 2014, 11:31:31 AM7/13/14
to mainfr...@googlegroups.com

Subhrangshu Mukherjee

unread,
Jul 14, 2014, 12:15:41 PM7/14/14
to mainfr...@googlegroups.com
Select MAX(emp_salary) from employee_tbl
where emp_salary not in (Select MAX(emp_salary) from employee_tbl
                                      where emp_salary not in (Select MAX(emp_salary) from employee_tbl));

Thank you,
Subhrangshu.

On Sunday, July 13, 2014 9:01:31 PM UTC+5:30, guptagurumukh wrote:

Reply all
Reply to author
Forward
0 new messages