Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153811 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / pardeep kumar
This is the Simplest One
Let i have a Column named EmpSal in Tbale Named tbEmp
Select Min(EmpSal) from tbEmp where EmpSal IN(Select
Distinct Top 3 EmpSal from tbEmp ORDER BY EmpSal DESC)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is key preserved table?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is the simplest tool to run commands on oracle servers?
What is meant by raw datatype?
How do I manually uninstall oracle client?
What happens in oracle commit?
what is port in oracle? how is it related to database application.
What is the string concatenation operator in oracle?
Explain about achiever in sql?
How to convert characters to times in oracle?
How do you tell what your machine name is and what is its IP address?
Explain oracle insert into command?
How to create a stored function in oracle?
How will you write a query to get a 5th rank student from a table student_report?
