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
What are different joins used in sql?
Is big data nosql?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Is sql a programming?
how to create a new table in mysql? : Sql dba
What is varchar used for?
what are set operators in sql? : Sql dba
What is field delimiter?
What are secondary keys?
What is the purpose of a sql?
what is a tablespace? : Sql dba
Mention what is the use of function "module procedure" in pl/sql?
What is graph sql?
What is sqlca in db2?
Why is pl sql used?
