Interested to Buy Any Domain ? << Click Here >> for more details...
Find out the 3rd highest salary?
- 51 Answers
- 72820 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
Are left and right joins the same?
What does (+) mean in sql joins?
What is primary and foreign key?
Why use triggers in sql?
What is clause in sql?
What is rowid in sql?
Explain the significance of the & and && operators in pl sql.
Can we call procedure in select statement?
Does truncate remove indexes?
How many types of normalization are there?
How to set up sql*plus output format in oracle?
What is varchar sql?
What is the difference between function, procedure and package in pl/sql?
How to display the current date in sql?
What is the difference between python and sql?
