Interested to Buy Any Domain ? << Click Here >> for more details...
Find out the 3rd highest salary?
- 51 Answers
- 74137 Views
- BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
- E-Mail Answers
Answer Posted / aarti verma
get the 3rd highest salary:
SELECT DISTINCT salary from employee e ORDER BY salary DESC
LIMIT 2,1;
get the records of employees having 3rd highest salary:
SELECT * FROM employees WHERE salary = (SELECT DISTINCT
salary from employee e ORDER BY salary DESC LIMIT 2,1);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is pl sql useful?
How can a pl sql block be executed?
Explain correlated query work?
what are the differences between char and varchar? : Sql dba
How to run sql commands in sql*plus?
What is the maximum number of columns in sql table?
Why is pl sql needed?
What is difference between mysql and postgresql?
how many groups of data types? : Sql dba
How can check sql version from command line?
What is auto increment feature in sql?
How many types of functions are there in sql?
Can you do multiple joins in sql?
How do I find duplicates in two columns?
What is varchar sql?
