User Answers - GeekInterview.com

Home

Answered Questions

Find out nth highest salary from emp table

Asked By: Interview Candidate | Asked On: Aug 29th, 2004

Select distinct (a.Sal) from emp a where &n = (select count (distinct (b.Sal)) from emp b where a.Sal < = b.Sal);for eg:-enter value for n: 2sal---------3700

Answered by: bhavikgore on: Oct 27th, 2012

This will work for only highest salary n=1 but not work for 2nd and rest nth salary...
Did you have tried this?

Answered by: rohitosu on: Jul 30th, 2012


Code
 SELECT * FROM  (SELECT employee_id, salary, dense_rank() OVER ( ORDER BY salary DESC)  r 
  FROM employees) a 
  WHERE a.r =3 ;

User Panel

Lost Password

Get Activation Code

Interview Coaching

Importance of an MBA for an entrepreneur

How do you deal and overcome major challenges?

How do you handle difficult situations?

What is the role of a mechanical engineer in the Software Industry?

How to handle academic gap while applying for a job?

Describe a time when you had to work under pressure.

Careers and Higher Education Options for BBA Graduates

What are my options when I do not get a job after graduation?

Have you gone above and beyond your job description?

How do you handle pressure and stress?

User Panel

Categories

Interview Coaching

Interview Question

Career Counselling

GeekInterview

Popular Sections