Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 89832 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / padiya hiten
select * from emp e1 where (3=(select count(distinct
(e2.sal))from emp e2 where e2.sal>=e1.sal));
| Is This Answer Correct ? | 4 Yes | 6 No |
Answer / sumeet
select min(sal) from emp where sal in (select top 2 sal from
emp order by sal desc);
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / shachindra pandey
proc sql;
select id,name,population from populations where
population=(select max(population) from
populations
where population < (select max(population) from
populations));
quit;
| Is This Answer Correct ? | 18 Yes | 22 No |
Answer / tejinder
select salary from emp order by salary desc limit 0,1;
| Is This Answer Correct ? | 0 Yes | 5 No |
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to execute a stored procedure in oracle?
How to start a new transaction in oracle?
how to use sequence and what use of sequence cache
What is blob datatype?
How to export your own schema?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
what is the syntax of UPDATE command?
Explain the use of show option in imp command.
What operating systems are supported by oracle database 10g xe?
What is bulk copy or bcp in oracle?
How to select the name of employee who is getting maximum sal with out using subquery
Oracle General 
