Interested to Buy Any Domain ? << Click Here >> for more details...
Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
- 10 Answers
- 15700 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
How to create a new tablespace in oracle?
What is a cursor and what are the steps need to be taken?
Explain what are synonyms used for?
How to loop through data rows in the implicit cursor?
Explain the use of analyse option in exp command.
What is difference between truncate and delete?
Can a parameter be passed to a cursor?
What is bulk load in oracle?
What is the difference between view and materialized view in Oracle?
What is a cognitive schema?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What to do if dba lost the system password?
What is a sub query and what are the different types of subqueries?
What is a user account in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
