Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368409 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
what are string data types? : Sql dba
how can we know the count/number of elements of an array? : Sql dba
How to call shell script from pl sql procedure?
What are the subsets of sql?
Explain commit, rollback and savepoint.
How to start the command-line sql*plus?
What are the types of variable use in pl sql?
What is the best free sql database?
What does the sign mean in sql?
Is sql injection illegal?
explain the delete statements in sql
What is union and union all keyword in sql?
Can we perform dml on view?
Why do we use joins in sql?
How to get help at the sql prompt?
