how to check the 3rd max salary from an employee table?
- 23 Answers
- 30113 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
Please Help Members By Posting Answers For Below Questions
what is a database? : Sql dba
what is sql? : Sql dba
Is sql pronounced sequel or sql?
Is truncate ddl or dml?
Difference between truncate, delete and drop commands?
Is it possible to update views?
What are the types of keys?
What is sqlerrd?
what is a constraint? : Sql dba
What is embedded sql in db2?
How do I start sql from command line?
How to select random rows from a table?
Does pl/sql support create command?
What is mutating error in pl sql?
what are aggregate and scalar functions? : Sql dba
