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
- 7242 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 |
What is partitioned table in Oracle?
What is the exact use of Collections?
How to select some rows from a table in oracle?
What are the attributes that are found in a cursor?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
how to store only time in a data base table
What is oracle rownum?
What is a schema in oracle?
How to revoke create session privilege from a user in oracle?
What are the ansi data types supported in oracle?
How to use "for" statements in oracle?
Oracle General 
