find out the second highest salary?
Answers were Sorted based on User's Feedback
Answer / shiv prakash
select salary from(select rownum as r,salary from(select
rownum,salary from emp order by salary
desc))where r=2;
Is This Answer Correct ? | 20 Yes | 18 No |
Answer / annada
SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary
that will return 2nd highest salry .if we place insted of 1
as 2 then we can get 3 rd highest salary .
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / chaitanya pathak
select max(salary) from employee
whrere salary<(selsect max(salary) from employee)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sandeep
select max(sal) from emp where sal<(select max(sal) from emp);
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anitha
select min(salary)
from (select distinct salary
from employee
order by salary desc)
where rownum <= 2
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / radhiv kumar
PROC SQL;
SELECT MAX(SALARY) FROM RIGHTMER1
WHERE SALARY < SELECT MAX (SALARY)FROM RIGHTMER1;
QUIT;
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / naveen
selec * from emp e1 (n-1)=(select count(distinct(sal) from
emp e2 where e1.sal<=e2.sal))
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raghu
second highest salary department wise query would be this
select e.dept_id,e.salary,e.emp_name,e.rank from (select
dept_id,emp_name,salary,dense_rank() over (partition by
dept_id order by salary desc nulls last) rank
from employee)e
where e.rank = 2
Is This Answer Correct ? | 1 Yes | 0 No |
SELECT * FROM 'emp` WHERE salary < ( SELECT max( salary
)FROM emp ) ORDER BY salary DESC LIMIT 1
This is Mysql syntax, if you use Oracle just remove LIMIT 1
and put it ROWNUM=1;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ishrat ali
select max(salary) from employee where salary<(select max(salary) from employee);
Is This Answer Correct ? | 1 Yes | 0 No |
What are the attributes of cursor?
What are the uses of Database Trigger ?
How to end the current transaction in oracle?
How to view the tablespaces in the current database?
Difference between hot backup vs. Cold backup?
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
what is foreign key?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How do I manually uninstall oracle client?
Can a property clause itself be based on a property clause ?
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?