Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 91400 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
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 is a tns service name?
What privilege is needed for a user to create tables in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How do I find my oracle client driver version?
What is format trigger?
what are actual and formal parameters?
How would you go about verifying the network name that the local_listener is currently using?
What are the different windows events activated at runtime ?
What is the difference between 10g OEM and 11g OEM?
How would you begin to troubleshoot an ORA-3113 error?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Oracle General 
