How to Select second Maximum salary in a Table ?
- 13 Answers
- 12012 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / ranjith
select salary from table order by salaray desc limit 1,1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
how do u setup a replication site?
What is the sid in oracle?
How to join two tables in a single query using oracle?
How to display employee records who gets more salary than the average salary in the department?
What is a cursor and what are the steps need to be taken?
Explain the use of grant option in exp command.
How to write numeric literals in oracle?
How to see the table columns used in an index?
What are the different pseudo commands? Explain in general?
How to assign values to variables?
What is the difference between sharding and replication?
How to rebuild an index in oracle?
What is a system tablespace and when it is created?
Explain the different normalization forms?
ABOUT IDENTITY?
