find out the second highest salary?

Answer Posted / raunaq

to all the people who are using rownum in their queries...

This query will not work if you have more than 1 person
having the second highest salary

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1857


does the query needs a hint to access a materialized view?

1478


What to do if the startbd.bat failed to start the xe instance?

615


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1868


What is a dynamic performance view in oracle?

615






How would you change old and new values in an insert, delete and update triggers?

549


Explain the characteristics of oracle dba?

645


Can multiple cursors being opened at the same time?

623


How many types of segments in Oracle?

540


How to write date and time interval literals in oracle?

588


Explain database link?

676


Why do we use bulk collect in oracle?

581


what is reindexing?

1186


What happens if variable names collide with table/column names?

593


How are extents allocated to a segment?

589