how to get top two salaries from employee tables

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

More Manual Testing Interview Questions

what is sychronization point in qtp how u put in yr application when it is put wat is its use how it is useful

3 Answers   Polaris, Quick Heal, SAP Labs,


What is diff. between System Testing and Integration Testing ?

3 Answers   TCS,


What is the basic difference between Alpha and beta testing??

4 Answers   DigiTech,


please answer, What is the Gap Analysis?

3 Answers   Yardi,


differnce between testing life cycle and bug life cycle?

3 Answers   SoftSmith,






define Testing of Procedure, Triggers and Functions in data base testing ?

0 Answers   CSS, Hexaware,


how to write test cases for boundary value analysis and equality partitioning?

1 Answers   Steria,


What is bug priority?

0 Answers  


What are the advantage of using V models?

5 Answers   Persistent,


How do you react when the developer says that defect you logged is not valid?

2 Answers   L&T, MTN,


!. what are the entry eriteria for functiondity and performance testing ?

1 Answers  


from where do u collect test data if u miss some data what will happen

0 Answers   Infosys,


Categories