Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / sagar
Select Min(Salary) from Curtest where Salary
in (select Top 2 Salary from Curtest order by salary desc)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql engine in oracle?
Can a table contain multiple primary key’s?
What does select count (*) mean in sql?
What is the difference between instead of trigger and after trigger?
How insert into statements in sql?
what are all the common sql function? : Sql dba
What is java sql drivermanager?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
How do I view an execution plan in sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
Is sqlexception checked or unchecked?
Is not equal in sql?
What are the types of variables use in pl sql?
What are different types of statements supported by sql?
what is a constraint? Tell me about its various levels. : Sql dba