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 the advantages of pl sql over sql?
How to select unique records from a table?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is the unique index?
State few characteristics of pl/sql?
What is a variable in sql?
What is the trigger in sql?
What is difference between left and right outer join?
What is difference between hql and native sql?
What is count * in sql?
What is cross join sql?
Do foreign keys improve performance?
What is a natural join sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is the difference between python and sql?