User Answers - GeekInterview.com

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

Provide an example of a goal that you successfully attained.

How do you approach a problem?

What is your way of building rapport with a person you just met?

Do you seek advice from others when you have a question?

Do you like working in a team or alone? Explain.

Tell me three things about you, which are not found in your resume

Careers and Higher Education Options for BBA Graduates

BPO Career for BTech Graduates

Has there been a time when you were presented a problem and solved it?

Have you experienced being given too many tasks?

User Panel

Categories

Interview Coaching

Interview Question

Career Counselling

GeekInterview

Popular Sections