how to check the 3rd max salary from an employee table?
- 23 Answers
- 33842 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pavan ranga
select top 1 (salary),Name from customers
where salary not in (Select top 2 (Salary) from customers)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What program will open a mdb file?
what are the difference between clustered and a non-clustered index? : Sql dba
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Is sql a programming?
How many rows can sqlite handle?
How can we store rows in PL/SQL using array?
what is the use of double ampersand (&&) in sql queries?
What is rank () in sql?
What are field types?
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
Is primary key an index?
what is a unique key ? : Sql dba
discuss about myisam key cache. : Sql dba
what are the differences between binary and varbinary? : Sql dba
What is the purpose of design view?
