Find out the 3rd highest salary?
- 51 Answers
- 64609 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
Why stored procedure is faster than query?
How do you write an index?
Explain dml and ddl?
What is plpgsql language?
What is the difference between left join and right join?
what is 'trigger' in sql? : Sql dba
Name the operator which is used in the query for pattern matching?
Explain two easy sql optimizations.
What is the meaning of disabling a trigger?
Which is faster truncate or drop?
What is sql trigger example?
What is cartesian join in sql?
Show how functions and procedures are called in a pl/sql block.
What does the base_object_type column shows in the user.triggers data dictionary view?
What is a sql driver?
