Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373088 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 / abhijeet banarse
Select level,Max(sal) from emp1
Where level=&level connect by prior sal>sal
group by level;
Enter the level No=2 (Here enter 2 manually)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what are numeric data types? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
What are inner and outer joins examples of both?
Does truncate release storage space?
Define union, minus, union all, intersect ?
What is synchronized subquery?
What is a pdo connection?
what is top in tsql? : Transact sql
What is the purpose of the sql select top clause?
How to return an array from java to pl/sql?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What does pl sql stand for?
What are all the different types of indexes?
What are the different types of dbmss?
What is sql deadlock?
