how to find the second highest salary from emp table?
- 211 Answers
- 321955 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 / arvind
select max(salary) from table_name where sal<(select
max(salary) from table_name)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I start sql profiler?
What is the difference between numeric and autonumber?
What is inner join in sql?
Explain the order of sql statement execution?
How does a trigger work?
What is localdb mssqllocaldb?
How can you tell the difference between an index and a view?
What is view? Can we update view
What are properties of the transaction?
What is the difference between sum and count in sql?
Is like operator in sql case sensitive?
What are the different types of constraints?
Which is better trigger or stored procedure?
What is the current version of postgresql?
What are %type and %rowtype for?
