Interested to Buy Any Domain ? << Click Here >> for more details...
i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table
- 3 Answers
- 6246 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohan
select max(sal) from emp where sal<(select max(sal) from
emp)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / surya
select * from emp where 2-1=(Select count(distinct(sal)
from emp e where emp.sal<e.sal and ename='mr.b.travel)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / obulesu
select * from (select e.*,dense_rank() over(order by sal desc) r from emp e) where r=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
How to assign data of the deleted row to variables?
What is ASM (Automatic Storage Management) in Oracle?
How to add another datafile to a tablespace?
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
How to omit columns with default values in insert statement in oracle?
What happens if you use a wrong connect identifier?
What is redo log?
Is oracle an operator?
Can you drop an index associated with a unique or primary key constraint?
why can't we assign not null constraint as table level constraint
What is meant by an index?
Difference between varchar and varchar2 data types?
Oracle General 
