Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / deepa
select min(salary) from (select salary from table_name order by salary desc) where rownum<3;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is blind sql injection?
How to add new employee details in an employee_details table with the following details
What is loop in pl sql?
What is denormalization in a database?
What is composite primary key in sql?
How to create an array in pl/sql?
What is nosql example?
Does inner join return duplicate rows?
How do I add a database to sql?
Determine if oracle date is on a weekend?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
Mention what pl/sql package consists of?
Explain cursor types?
what are the t string functions available in tsql? : Transact sql
Why is pl sql needed?