Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 150727 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
How do we get field detail of a table?
List out the difference between commit, rollback, and savepoint?
How to update a table row with a record?
please explain.. DB architecture ...
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How will you write a query to get a 5th rank student from a table student_report?
What are the ways tablespaces can be managed and how do they differ?
Explain an index?
what is meant by magic query
how to handle exceptions in post production
How does Oracle guarantee data integrity of data changes?
Why packages are used in oracle?
what is the difference between data migration and production migration.
Name the various constraints used in oracle?
Explain what are synonyms used for?
