Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118052 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / niladri saha(oracle apps consu
SELECT EMP_NAME EmployeeName, SAL Salary
FROM EMP
WHERE SAL =
( SELECT SAL
FROM
(
SELECT
DISTINCT SAL
FROM EMP
ORDER BY SAL DESC
)
WHERE ROWNUM=2
);
This Query will list all the employees, having second
highest salary.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are some emotional triggers?
How do I add a database to sql?
Are left and right joins the same?
what is column? : Sql dba
What is java sql connection?
What is data modelling in sql?
How to run sql statements through the web interface?
What do you mean by field in sql?
What is difference between primary and secondary key?
What is normalisation in sql?
Is it possible for a table to have more than one foreign key?
what is csv? : Sql dba
What is thread join () in threading?
Is nosql relational?
What is the difference between an inner join and an outer join?
