i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table
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 run the anonymous block again?
How can we force the database to use the user specified rollback segment?
How to use "in" parameter properly?
How to select the name of employee who is getting maximum sal with out using subquery
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
Can objects of the same Schema reside in different tablespaces.?
What is PL/SQL ?
What are the differences between blob and clob in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Explain the use of inctype option in exp command.
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is raw datatype in oracle?