Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 27777 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajasekhar.v
For selecting Nth highest salary...
SQL> select rownum rank,ename,sal from
(select ename,sal from emp order by sal desc)
group by rownum,ename,sal
having rownum = &n;
'n' may be any valid number required..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is PL/SQL Records?
Is sqlite good enough for production?
what is table? : Sql dba
Why do we go for stored procedures?
What trigger means?
How do you remove duplicates without using distinct in sql?
What is an inner join sql?
What is the best free sql database?
What is a delimiter in sas?
What is a database event trigger?
what are the different functions in sorting an array? : Sql dba
How to use transactions efficiently : transact sql
How do I partition a table in sql?
What are all the ddl commands?
