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
How many indexes can be created on a table in sql?
Does a user_objects view have an entry for a trigger?
What is rtm stands for?
What is substitution variable in pl sql?
What are the features of pl sql?
What is sqlerrm?
What is dba in sql? : SQL DBA
what is 'mysqlimport'? : Sql dba
how is exception handling handled in mysql? : Sql dba
What are the operators used in select statements?
How to fetch alternate records from a table?
What is difference between pl and sql?
How do I save a sql query?
How do I enable sql encryption?
Define commit, rollback and savepoint?
