User Answers - GeekInterview.com

Home

Answered Questions

What is the querry for retrieving the 2nd highest salary in a table?

Asked By: suman | Asked On: Mar 18th, 2006

68 answers

Read Best Answer

Editorial / Best Answer

Answered by: muralir02

View all answers by muralir02

Member Since Mar-2006 | Answered On : Mar 20th, 2006

select max(sal) from emp where sal<(select max(sal) from emp);

Answered by: sampra on: Mar 6th, 2012

select salry from Hello h where 2=(select count (distinct salry) from hello where h.salry

Answered by: srivathson on: Feb 20th, 2012


Code
SELECT max(Salary) WHERE salary<Select max(Salary) FROM employees

Find out nth highest salary from emp table

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

62 answers

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

Give me good reasons why should I choose you over others.

Do you have any questions that you want to ask?

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

How to handle academic gap while applying for a job?

Describe a time when you had to work under pressure.

How to Overcome Employment Gap during interview.

What are the things you wish to achieve in 5 years?

How do you handle workplace problems?

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

Does a problem make you a better person?

Editorial / Best Answer

User Panel

Categories

Interview Coaching

Interview Question

Career Counselling

GeekInterview

Popular Sections