Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373295 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 / praveen
SELECT MAX(Salary) as 'Salary' from EmployeeDetails
where Salary NOT IN
(
SELECT TOP 1 (SALARY) from EmployeeDetails ORDER BY Salary Desc
)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to create a test table in your mysql server? : Sql dba
what are all the different normalizations? : Sql dba
what is a database lock ? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is sql analyzer?
Is it possible to create startup or shutdown trigger for on-schema?
How much does sqlite cost?
Does asenumerable execute the query?
describe transaction-safe table types in mysql : sql dba
What is program debugging?
Is it possible for a table to have more than one foreign key?
What are the two types of cursors in pl sql?
Difference between truncate, delete and drop commands?
What makes a good primary key?
How many postgresql users are there, worldwide?
