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
- 6254 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 the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
12. Display the client name in upper case only and in lower case only.
What is connection pooling in oracle?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is difference between cartesian join and cross join?
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
What is a procedure in oracle?
Differentiate between pre-select and pre-query?
What is oracle database 10g express edition?
Can objects of the same schema reside in different tablespace?
Give the advantages and disadvantages of clusters.
Oracle General 
