Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151551 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 SQL Tuning Advisor in Oracle?
What is oracle database client?
What are named parameters?
What to do if dba lost the system password?
what are archived logs?
How to write a left outer join with the where clause in oracle?
How do you tell what your machine name is and what is its IP address?
Explain the use of record length option in exp command.
Explain the difference between replace() and translate() functions in oracle?
What is a procedure in oracle?
What is a nvl function? How can it be used?
How to create an oracle testing table?
Difference between the “verify” and “feedback” command?
What is format trigger?
What is execute immediate in oracle?
