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
- 6145 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 |
What is varray?
what is the difference between oracle enterprise edition and oracle express edition?
What is the difference between a primary key & a unique key?
List out the types of joins.
How index is implemented in oracle database?
How many types of cluster table in Oracle?
What is the use of Control File ?
What is oracle latest version?
What is the maximum limit on the number of columns in a table?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
Explain the use of constraints option in exp command.
how to get count of tables in particular database in Oracle?
Oracle General 
