Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373261 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
how to dump a table to a file with 'mysqldump'? : Sql dba
What do you mean by field in sql?
What is sql trigger example?
Can I call a procedure inside a function?
Can a foreign key have a different name?
What is difference between inner join and self join?
Could you please provide oca (oracle 10g) dumps for my certification ?
How do I get sql certification?
How many types of cursors are available in pl/sql?
How do you update a value in sql?
What is cold data?
What are the disadvantages of file system?
What is union?
What is an inner join sql?
What is the syntax and use of the coalesce function?
