how to find the second highest salary from emp table?
- 211 Answers
- 322609 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 / udayalakshmij
select emp_name,max(salary) from emp except(select max(salary) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between nvl function, ifnull function, and isnull function?
What is the difference between inner join and outer join?
Can instead of triggers be used to fire once for each statement on a view?
In pl/sql, what is bulk binding, and when/how would it help performance?
How can we make an if statement within a select statement?
What is offset in sql query?
Can we use two order by clause in query?
What is program debugging?
What is the max nvarchar size?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Is sql difficult?
Can we insert in sql function?
What is scope and visibility in PL/SQL?
Is pl sql different from sql?
what are the different index configurations a table can have? : Sql dba
