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
- 6134 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the use of compress option in exp command.
What privilege is needed for a user to create indexes in oracle?
How to define a data field as not null?
How to use like conditions in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is bulk load in oracle?
Difference between cartesian join and cross join?
How to update a table row with a record?
What is coalesce function?
What is materialized view in Oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is an oracle function?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Explain view?
How to bring a tablespace online?
