find out the second highest salary?
- 55 Answers
- 78902 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 |
How to view the tablespaces in the current database?
Explain a private synonyms?
State the various uses of dbcc command?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to invoke the data pump export utility?
find out first highest salary?
10 Answers Verinon Technology Solutions,
How to retrieve values from data fields in record variables?
How would you go about verifying the network name that the local_listener is currently using?
Describe an oracle table?
How to update values on multiple rows in oracle?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
How to commit the current transaction in oracle?
Oracle General 
