Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
- 10 Answers
- 12703 Views
- Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon, I also Faced
- E-Mail Answers
Answer Posted / martin
select e.sal from emp e where &2>(select max(count{a.sal})
from emp a where a.sal > e.sal order by desc
)
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is an oracle wallet?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is system global area (sga) in oracle?
How can you use check constraints for self referential integrity?
Is there an oracle sql query that aggregates multiple rows into one row?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is logical backup in oracle?
How to revoke create session privilege from a user in oracle?
What is a data lock in oracle?
Explain the use of tables option in exp command.
What is a cognitive schema?
How to create a stored program unit?
What are the differences between lov and list item?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
