Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118820 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
Which are the different types of indexes in sql?
How can you create an empty table from an existing table?
Explain autonomous transaction.
what is the difference between union and union all? : Sql dba
What is meant by <> in sql?
What is sqlservr exe?
Differentiate between sga and pga.
what are the non-standard sql commands supported by 'mysql'? : Sql dba
How do I find duplicates in a single column in sql?
What is a rank in sql?
Can we join two tables without common column?
Is primary key clustered index?
How many types of literals are available in pl sql?
What is sql architecture?
How delete all records from table in sql?
