Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...

Answer Posted / mahaboob

I would say that Raj has given the correct answer in general.

In most cases the interviewer restricts the parameter to be
written in the query as it might effect the performance.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can Oracle users be audited?

610


can u plz provide me oca sql dumps please i need them

1466


Explain the use of ignore option in imp command.

575


What is set operator oracle?

528


How to view the data files in the current database?

592






How to run the anonymous block again?

595


How to drop an existing table in oracle?

592


What is a package in oracle?

565


How to add another datafile to a tablespace?

577


What are dml statements in oracle?

619


List the parts of a database trigger.

580


How to convert times to characters in oracle?

607


what is the difference between restoring and recovering?

558


How would you go about verifying the network name that the local_listener is currently using?

1605


Write a trigger example in oracle?

573