1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
- 6 Answers
- 6921 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramya
select max(sal) from employees where
sal < (select max(sal) from employees)
| Is This Answer Correct ? | 21 Yes | 2 No |
Answer / neha k
select sal
from (SELECT sal, rownum row_num
FROM emp
order by sal desc)
where row_num = 2;
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / hema
Select sal from emp a where 2=(select count(distinct sal)
from emp b where a.sal <= b.sal)
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / esakkiraja
select a.* from(select dense_rank() over(order by sal)as
new_rank from emp) a where new_rank=2
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / swapna
select top(2) sal from emp where sal order by desc
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / swapna
select top(1) sal From sample
where sal
in (select top(2) salfrom sample order by saldesc)
order by sal asc
| Is This Answer Correct ? | 0 Yes | 7 No |
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to call a stored function in oracle?
What are advantages fo Stored Procedures?
Point out the difference between user tables and data dictionary?
how to select second mauximum value in a given table under salary column
Explain a private synonyms?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
1.display list of all users from ur data base.what is the query?
can u call user defined functions in select statements
What do you know about normalization? Explain in detail?
Briefly explain what is literal? Give an example where it can be used?
What is a server parameter file in oracle?
Oracle General 
