Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147742 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 set operator oracle?
Is oracle the best database?
Give the various rollback segment states.
How to execute a stored program unit?
Is truncate autocommit in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to get maxsal , minsal, ename department wise in single query
How to get execution path reports on query statements?
Explain the different normalization forms?
Explain the use of full option in exp command.
Use of an integrity constraint is better to validate data. Explain
How to rebuild an index in oracle?
does the query needs a hint to access a materialized view?
Explain the dml?
What is the difference between formal parameters and actual parameters?
