Interested to Buy Any Domain ? << Click Here >> for more details...
Find out the 3rd highest salary?
- 51 Answers
- 73505 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
What are the differences between implicit and explicit cursors?
How do I run a pl sql program?
What are its different types of dbms?
What is null in pl/sql?
What is rename command in sql?
How many databases can sql express handle?
what is online transaction processing (oltp)? : Sql dba
what is the stuff function and how does it differ from the replace function? : Sql dba
Why is sql*loader direct path so fast?
how to create a new view in mysql? : Sql dba
What is sql performance tuning?
What do you think about pl/sql?
How to use sql*plus built-in timers?
What is %type in pl sql?
What are sql procedures?
