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 the types of functions in sql?
How can one get sql*loader to commit only at the end of the load file? : aql loader
How does sql store data?
Explain the components of sql?
Is clustered index a primary key?
What is a function in oracle pl sql?
What is the purpose of normalization?
Explain the structure of pl/sql in brief.
what is the difference difference between procedure and packages
What is localdb mssqllocaldb?
How to use sql statements in pl/sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is restrict in sql?
How do I remove all records from a table?
what is meant by urlencode and urldocode? : Sql dba
