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 ordinary table in oracle?
What is the database name in oracle?
How to use "while" statements in oracle?
What is ceil and floor in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is an oracle transaction?
what is the difference between restoring and recovering?
What do you know about normalization? Explain in detail?
How to retrieve the count of updated rows?
What is the usage of synonyms?
What is set operator oracle?
What exactly do quotation marks around the table name do?
What is ADDM Advisor in Oracle?
What is oracle rownum?
can anyody please send me the dump for Oracle 10g certifications for DBA path?