find out the second highest salary?
Answer Posted / ved
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How would you change old and new values in an insert, delete and update triggers?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to define a procedure inside another procedure?
How can we force the database to use the user specified rollback segment?
How to create a table in a specific tablespace?
How do we create privileges in oracle?
How to display row numbers with the records?
What the is the diff between local index and global index. give some example.
How to put more than 1000 values into an oracle in clause?
Explain the use of log option in exp command.
How do I know if oracle client is installed on windows?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to use "while" statements in oracle?
Is truncate autocommit in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?