Interested to Buy Any Domain ? << Click Here >> for more details...
Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
- 10 Answers
- 15055 Views
- Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raj
select max(sal) from emp where sal < (select max(sal) from
emp)
| Is This Answer Correct ? | 31 Yes | 1 No |
Answer / selvaraj anna university coe
Oracle 10g Using : Find 2nd Highest Salary?
SELECT * FROM emp e WHERE 2=(SELECT COUNT(DISTINCT salary)
FROM emp x
WHERE x.salary >= e.salary);
Answer :
EMP_NO EMP_NAME SALARY
--------- ------------------------- ---------
107 SARABOOT 550000
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / mahaboob
I would say that Raj has given the correct answer in general.
In most cases the interviewer restricts the parameter to be
written in the query as it might effect the performance.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / amitkumar
Select TOP 1 salary from (select Distinct TOP 2 salary from
employee orderby salary desc)
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / samad
Dear
here i am sending new ans u can give the value in parameter
SELECT SAL,NO FROM(
SELECT SAL ,ROWNUM NO FROM
(SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC)) WHERE NO=:N
Regards,
Samad
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / hemalatha
Following is the query to find the nth maximum salary:
select * from emp
where sal=(select distinct(sal) from emp a
where &n=(select count(sal)from emp
where sal>=a.sal;))
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / keerthi
select(max(salary)
from employee
where sal>max salary&salary<max salary-1;
if you say no to my answer plz correct me.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / apsar
select sal from (select sal,count(sal) over order by salary desc c)temp where temp.c=&n;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / martin
select e.sal from emp e where &2>(select max(count{a.sal})
from emp a where a.sal > e.sal order by desc
)
| Is This Answer Correct ? | 1 Yes | 4 No |
How to lock and unlock a user account in oracle?
Can a property clause itself be based on a property clause ?
What types of joins are used in writing subqueries?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What are Schema Objects ?
Explain a synonym?
Explain oracle’s server parameter file.
What are various joins used while writing SUBQUERIES?
How to define an oracle sub procedure?
What is an Index ? How it is implemented in Oracle Database ?
Can group functions be mixed with non-group selection fields?
Why does Oracle not permit the use of PCTUSED with indexes?
Oracle General 
