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 range partitioning?
What is the difference between the conventional and direct path loads? : aql loader
how to calculate the difference between two dates? : Sql dba
What is equi join in sql?
Which one is better subquery or joins?
Is sql a dbms?
what is the difference between join and union? : Sql dba
How do you sort in sql?
How do you update f as m and m as f from the below table testtable?
What is time based sql injection?
what are the different tables present in mysql? : Sql dba
What is record in pl sql?
Are stored procedures compiled?
What is on delete set null?
Is delete faster than truncate?