Query for second maximum salary in each in each department
Answer Posted / arvind kumar
select * from employees e where (select count(salary) from
employees where salary >=e.salary)=2;
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the trigger in sql?
Why select is used in sql?
What are the advantages of normalization?
Where not exists in sql?
Explain the difference between drop and truncate commands in sql?
What if we write return in procedure?
Inline the values in PL/SQL, what does it mean.?
What is a stored procedure in sql with example?
What is cte?
What is blind sql injection?
What are inner and outer joins examples of both?
Can you join a table to itself?
What is an inner join sql?
Explain some predefined exceptions.
how to use in conditions? : Sql dba