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 are commit, rollback, and savepoint?
What do you mean by stored procedures? How do we use it?
What plvcmt and plvrb does in pl/sql?
What is the difference between union and union all command?
What does trigger mean in psychology?
What is the use of %rowtype?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is the command used to fetch first 5 characters of the string?
What do you mean by “trigger” in sql?
What is materialized view. What are different methods of refresh?
How do I remove sql plus from windows 10?
Mention what are the benefits of pl/sql packages?
How is debugging done?
Does truncate require commit?