Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120161 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
Can I learn sql in a week?
Explain the working of primary key?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What are the commands used in sql?
How do you update a value in sql?
When you have to use a default "rollback to" savepoint of plvlog?
How do I make sql search faster?
write an sql query to find names of employee start with 'a'? : Sql dba
Mention what pl/sql package consists of?
what are all types of user defined functions? : Sql dba
Is natural join and inner join same?
Which command is used to call a stored procedure?
who introduced sql?
what are tables and fields? : Sql dba
what is the syntax used for partition in tsql? : Transact sql
