Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367687 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 / shanmugasundaram
select min(salary) from tblempsal where salary in(select
distinct
top 2 salary from
tblempsal order by salary desc)
| Is This Answer Correct ? | 20 Yes | 13 No |
Post New Answer View All Answers
Can a commit statement be executed as part of a trigger?
Where is sql database stored?
Do we need commit after truncate?
What are the benefits of pl sql?
What is the meaning of disabling a trigger?
What is a temp table?
What are tables and fields in the database?
What are character functions?
Is nosql relational?
Can two tables have same primary key?
Why is sharding used?
Explain about various levels of constraint.
give the syntax of grant and revoke commands? : Sql dba
How exception handling is done in advance pl/sql?
What is pivot in sql?
