how to check the 3rd max salary from an employee table?
- 23 Answers
- 29763 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / neeraj79
SELECT DISTINCT salary
FROM employee
ORDER BY salary DESC
LIMIT(2,1)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is csv? : Sql dba
What is the difference between left and left outer join?
How many row comparison operators are used while working with a subquery?
What is a pl/sql block?
difference between anonymous blocks and sub-programs.
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What schema means?
What is spool?
what is denormalization. : Sql dba
Are there any features that are decommissioned in 11g that are not present in 11g?
What is sql injection owasp?
Why do we need sharding?
what is 'trigger' in sql? : Sql dba
Which join is default?
What is set transaction?
