How to Select second Maximum salary in a Table ?
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
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is oracle sid?
Where are the settings stored for each instance in oracle?
How to count groups returned with the group by clause in oracle?
How to drop an existing table in oracle?
What is not equal to in oracle?
What is a database table in oracle?
How to update values on multiple rows in oracle?
How to view existing locks on the database?
what is reindexing?
How to check the oracle tns settings?
What is ADDM Advisor in Oracle?
What is transport network substrate (tns) in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to write a query with an inner join in oracle?