Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / srinivas
select max(salary) from Emp where salary<(select max(salary) from Emp)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sqlerrm?
What is count * in sql?
How many clustered indexes can you have?
When do we use triggers?
What is the use of procedures?
Why partition by is used in sql?
Can ddl statements be used in pl/sql?
How to create a menu in sqlplus or pl/sql?
What do you understand by exception handling in pl/sql?
What is on delete restrict?
what is the difference between inner and outer join? Explain with example. : Sql dba
Does normalization improve performance?
What is java sql connection?
What is varchar example?
What are the different operators available in sql?