Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / yankee
select * from (select * from <table_name> order by salary
desc)where rownum<4
---this way u can get the record of the top 3 salaries and
easily filter out the 3rd positioned salary from there.
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
Can we delete column in sql?
What is query syntax?
How to set up sql*plus output format in oracle?
What is sql used for?
What is the difference between a subquery and a join?
How to take user input in pl sql?
what is a record in a database ? : Sql dba
Does pl sql work in mysql?
What is indexing oracle sql?
How do I write a sql query in pgadmin 4?
What is record type in pl sql?
What does stand for in sql?
Explain the components of sql?
Does normalization improve performance?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
