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
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
does the query needs a hint to access a materialized view?
What to do if the startbd.bat failed to start the xe instance?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is a dynamic performance view in oracle?
How would you change old and new values in an insert, delete and update triggers?
Explain the characteristics of oracle dba?
Can multiple cursors being opened at the same time?
How many types of segments in Oracle?
How to write date and time interval literals in oracle?
Explain database link?
Why do we use bulk collect in oracle?
what is reindexing?
What happens if variable names collide with table/column names?
How are extents allocated to a segment?