Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
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 where clause in oracle?
How to start your 10g xe server?
What is oracle open database communication (odbc)?
what is the difference between functional dependecy and multilevel dependency?
How to use values from other tables in update statements using oracle?
What happens to indexes if you drop a table?
can u plz provide me oca sql dumps please i need them
How do I limit the number of oracle database connections generated by weblogic server?
What is a sub query? Describe its types?
what are the advantages of running a database in archive log mode?
query optmization techniques and quwry analyser+projects+ppts
How to open a cursor variable?
What is the difference between a user and a schema in oracle?
How to login to the server without an instance?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.