how to find the second highest salary from emp table?
- 211 Answers
- 320833 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 / satish kumar
Select Top1 salary
from(select Distinct Top2 salary from employee order by salary DESC) a order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which are the different case manipulation functions in sql?
What is a trigger word?
What is use of term?
What is a unique key and primary key and foreign key?
what is the difference between where clause and having clause? : Sql dba
What is a natural join?
What is the difference between view and stored procedure?
Why is normalization important?
What will you get by the cursor attribute sql%found?
What are the different types of constraints?
What is a database trigger?
Is sql open source?
Does view store data in sql?
How to add new employee details in an employee_details table with the following details
describe mysql connection using mysql binary. : Sql dba
