find out the third highest salary?
Answers were Sorted based on User's Feedback
Answer / ashutosh pandey
select sal from emp
where sal=(select min(sal) from emp
where sal>(select min(sal) from emp
where sal>(select min(sal) from emp);
| Is This Answer Correct ? | 69 Yes | 204 No |
How do you tell what your machine name is and what is its IP address?
Is there a function to split a string in plsql?
How to use "if" statements on multiple conditions?
WHT ARE THE AGGREATE FUNCTIONS?
What is meant by an index?
What is oracle server autotrace in oracle?
What are the differences between char and varchar2 in oracle?
How to login to the server without an instance?
What is forall Statement ?
What are inner join and outer join?
What is the difference between translate and replace?
What is the difference between 10g OEM and 11g OEM?