Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118055 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / kirti
Very simple answer: Arrange the top two salaries in
decending order. Select the mininum salary.
Select min(salary) from Employee where salary in(select top
2 salary from employee order by salary desc)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the use of friend function? : Sql dba
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
what are all the different normalizations? : Sql dba
Do stored procedures prevent sql injection?
Is there a 64 bit version of ssms?
What is linq to sql?
What is the clause we need to add in function body to return variable?
What are the syntax and use of the coalesce function?
What is pl sql and why it is used for?
What can I use instead of union in sql?
Is mariadb a nosql database?
How can we solve sql error: ora-00904: invalid identifier?
How does pl sql work?
What is dml with example?
Can dml statements be used in pl/sql?
