how to get top two salaries from employee tables

Categories >> Software >> Testing >> Manual Testing
Suggest New Category

Question Posted / maheswar

12 Answers
25433 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to get top two salaries from employee tables..

Answer / rituparna

select salary from (select salary from emp order by salary
desc)
where rownum < 3;

Is This Answer Correct ?

10 Yes

3 No

how to get top two salaries from employee tables..

Answer / maruti

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

with this query u ll get second largest sal of that table
if u want to know max (sal) then it ll be...
select Max(sal)
from emp;

Is This Answer Correct ?

4 Yes

0 No

how to get top two salaries from employee tables..

Answer / varu

This will be right answer for the query

Select * from empsal e where 2<=(select count(*) from empsal f
where e.sal>f.sal) order by sal desc

Is This Answer Correct ?

4 Yes

0 No

how to get top two salaries from employee tables..

Answer / charan

hi this is charan,
select e1 *from employees e1
where 2>
( select column(distincte2.sal)
where e2.sal>e1.sal )

Is This Answer Correct ?

4 Yes

1 No

how to get top two salaries from employee tables..

Answer / shiva - e-softsys

SELECT MIN (SALARY) FROM EMP WHERE

SALARY IN (SELECT DISTINCT TOP 2 SALARY FROM EMP ORDER BY
SALARY DESC)

Is This Answer Correct ?

4 Yes

1 No

how to get top two salaries from employee tables..

Answer / usha

select top 2 salary from employee order by desc

Is This Answer Correct ?

3 Yes

1 No

how to get top two salaries from employee tables..

Answer / rajendra prasad reddy penumall

this is a SQL query

SELECT DISTINCT salary FROM employee WHERE(max(salary))

Is This Answer Correct ?

3 Yes

3 No

how to get top two salaries from employee tables..

Answer / satya

Hi,

Select * from emp e where 2>=(select count(*) from emp e
where sal>e.sal) order by desc sal.

Let me know if this query is wrong.

Is This Answer Correct ?

2 Yes

2 No

how to get top two salaries from employee tables..

Answer / sivaprasad

SELECT MIN(SALARY) FROM EMP WHERE SALIN(DISTINCT TOP2
SALARY FROM EMP ORDER BY SALARY DESC.

OR
SELECT TOP 2 SALARY FROM EMP ORDER BY SALARY DESC.

Is This Answer Correct ?

2 Yes

2 No

how to get top two salaries from employee tables..

Answer / varu

writing this way is also correct

select sal
from empsal
where id > 2
order by sal desc

Is This Answer Correct ?

0 Yes

0 No

Post New Answer