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


Please Help Members By Posting Answers For Below Questions

What are the advantages of pl sql over sql?

548


How to select unique records from a table?

571


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

648


What is the unique index?

530


State few characteristics of pl/sql?

571






What is a variable in sql?

518


What is the trigger in sql?

542


What is difference between left and right outer join?

528


What is difference between hql and native sql?

585


What is count * in sql?

558


What is cross join sql?

505


Do foreign keys improve performance?

551


What is a natural join sql?

515


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

624


What is the difference between python and sql?

524