Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373023 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / latha l
Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;
ENTER THE LEVEL MANUALLY
EX:Enter value for level: 2
YOU GET SECOND MAXIMUM SALARY.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is sql open source?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
When should I use nosql database?
What is self-join and what is the requirement of self-join?
Which are the different types of indexes in sql?
Can we debug stored procedure?
what is a materialized view? : Sql dba
How many joins in sql?
How do I edit a trigger in sql developer?
What kind of join is join?
What is the difference between joins?
What are the types of sql commands?
Can we join two tables without common column?
What is mutating error in pl sql?
What is a subquery in sql?
