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
How to drop an existing table in oracle?
What is a subquery in oracle?
How to create an oracle testing table?
Can you drop an index associated with a unique or primary key constraint?
What is Undo Management Advisor in Oracle?
how the indexes are stored in the Oracle Database?
What is columnar storage what is the advantage?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is the scope of a local variable?
What is a database schema in oracle?
How will you write a query to get a 5th rank student from a table student_report?
What is execute immediate in oracle?
How to select an oracle system id (sid)?
Calculate difference between 2 date / times in oracle sql?
What is a nvl function?