Query for second maximum salary in each in each department
Answer Posted / yaswanth
select salary from(select salary,rownum rk from(select salary from employees order by salary desc)) ehere rk=2;
| Is This Answer Correct ? | 2 Yes | 13 No |
Post New Answer View All Answers
What does bitemporal mean?
Which are the different character-manipulation functions in sql?
How to run sql statements through the web interface?
Does sql use python?
What is mutating sql table?
Does sql between include endpoints?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is the starting oracle error number? What is meant by forward declaration in functions?
Is sql easier than java?
What is range partitioning?
What is a sql schema used for?
how to convert numeric values to character strings? : Sql dba
What if we write return in procedure?
Can we call procedure in select statement?
what is the different between now() and current_date()? : Sql dba