User Answers - GeekInterview.com

Home

Answered Questions

Dispaly employee records who gets more salary than the average salary in their department?

Asked By: kowmudiswarna | Asked On: Sep 14th, 2007

Answered by: farhan on: Apr 20th, 2012


Code
SELECT * FROM emp  WHERE sal >(SELECT avg(sal) FROM emp)

Answered by: uma on: Mar 5th, 2012

select * from emp a
where salary >(select avg(salary) from emp b where a.dept_no = b.dept_no);

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

Careers and Higher Education Options for BBA Graduates

What was the most important decision you ever had to make?

What do you do when someone criticizes you?

Have you gone above and beyond your job description?

How do you handle workplace problems?

Importance of an MBA for an entrepreneur

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

How to Overcome Employment Gap during interview.

Tell me about a skill you recently acquired or improved.

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

User Panel

Categories

Interview Coaching

Interview Question

Career Counselling

GeekInterview

Popular Sections