Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118664 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 aggregate and scalar functions?
How can we debug in PL/SQL?
Which operator is used in query for pattern matching?
What is data abstraction in sql?
What is a design view?
What is the purpose of the primary key?
How do I view tables in mysql?
What is the difference between a database and a relational database?
What are the sql commands?
What is the left table in sql?
Enlist some predefined exceptions?
What is synonyms?
What is the plv (pl/vision) package offers?
What is trigger types of trigger?
What is sqlcommand?
