Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368583 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 is the primary use of normalization?
How to sort the rows in sql.
How many types of relationship are there?
How many types of functions are there in sql?
How delete all data from table in sql?
Can we use view in stored procedure?
What are the different operators available in sql?
What is a natural join sql?
What is partition by in sql?
How much does a sql dba make? : SQL DBA
how to create a new table in mysql? : Sql dba
What do you mean by query optimization?
How do I view a sql trace file?
explain the difference between delete , truncate and drop commands? : Sql dba
How to process query result in pl/sql?
