Find out the 3rd highest salary?
Answer Posted / sachin saini
select min(salary) from table_name where salary in(select
top 3 salary from table_name order by salary desc )
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we insert in sql function?
Is sql a microsoft product?
how to include character strings in sql statements? : Sql dba
What is pl sql in oracle?
In a distributed database system, can we execute two queries simultaneously?
how to convert dates to character strings? : Sql dba
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What are the differences between implicit and explicit cursors?
How can you save or place your msg in a table?
How does rowid help in running a query faster?
What are the three pl sql block types?
What is sorting in sql?
what are all different types of collation sensitivity? : Sql dba
What is join view in sql?