how to check the 3rd max salary from an employee table?
- 23 Answers
- 30114 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 is a data manipulation language?
What is dense_rank?
What is meant by truncate in sql?
What is difference between hql and native sql?
How can the performance of a trigger be improved?
What does over partition by mean in sql?
What do you mean by query optimization?
How can we optimize a sql query?
What is the purpose of the sql select top clause?
How do I install microsoft sql?
What does the sign mean in sql?
What is a sql schema used for?
Explain the difference between 'between' & 'and' operators in sql
what are the join types in tsql? : Transact sql
What operating systems are supported by oracle sql developer?
