how to check the 3rd max salary from an employee table?
- 23 Answers
- 33843 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kotesh
select level,max(salary) from employee
where level=3
connect by prior salary>salary
group by level;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is rollback?
Does sql use python?
How long will it take to learn pl sql?
What is the plv (pl/vision) package offers?
What are inner outer left and right joins in sql?
How to return an array from java to pl/sql?
What are the syntax and use of the coalesce function?
What are the advantages of sql? Explain
How to display Row Number with Records in Oracle SQL Plus?
What is the maximum number of rows in sql table?
Compare sql & pl/sql
Can triggers stop a dml statement from executing on a table?
Is sqlite thread safe?
How do I run sql profiler?
