how to get top two salaries from employee tables
Answers were Sorted based on User's Feedback
Answer / rituparna
select salary from (select salary from emp order by salary
desc)
where rownum < 3;
Is This Answer Correct ? | 10 Yes | 3 No |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 ?
What is the basic difference between Alpha and beta testing??
please answer, What is the Gap Analysis?
differnce between testing life cycle and bug life cycle?
define Testing of Procedure, Triggers and Functions in data base testing ?
how to write test cases for boundary value analysis and equality partitioning?
What is bug priority?
What are the advantage of using V models?
How do you react when the developer says that defect you logged is not valid?
!. what are the entry eriteria for functiondity and performance testing ?
from where do u collect test data if u miss some data what will happen