Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28798 Views
- I also Faced
- E-Mail Answers
Answer Posted / kitcat
SELECT salary
FROM (SELECT salary FROM emp
ORDER BY DESC salary)
WHERE RowNum=2
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
What is sql scripting?
what is a cursor? : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is the use of desc in sql?
What is dynamic sql in pl sql?
Why use triggers in sql?
What are predefined functions in sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What does the sign mean in sql?
Can unique keys be null?
What are the different types of dbmss?
What are the benefits of pl sql?
Compare sql & pl/sql
What is mutating error?
how do you tune the slow running queries in oracle db , explain the methodology
