Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361149 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
What is a sql schema used for?
How do I pipe the output of one isql to another?
Explain what is a field in a database and record in a database?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
what is oracle database ? : Sql dba
What is pl sql collection?
How can we optimize a sql query?
Can we have two clustered index on a table?
What is t-sql? : Transact sql
What is left inner join in sql?
What is dense_rank in sql?
What is java sql drivermanager?
Which is faster union or join?
Mention what pl/sql package consists of?
what are dynamic queries in t-sql? : Transact sql
