Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368233 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 / anandaraj
This below query is used to get the name and salary of
second highest salary person. Its work great.
select Name, Salary from table_3 where salary = (select max
(salary) from table_3 where salary < (select max(salary)
from table_3 )).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we use procedures in sql?
What schema means?
what is try_catch block in procedure
What are records give examples?
What are the limitations of sql express?
What is mutating trigger?
What are triggers and its uses?
Advantages and disadvantages of stored procedure?
What is sql engine in oracle?
What are the different sql languages?
What is sql*loader and what is it used for?
What is a unique key?
Why do we use subquery?
What is structural independence and why is it important?
How many types of index are there?
