Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118639 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
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
define data blocks ? : Sql dba
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How can a pl sql block be executed?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are the limitations of sql express?
What is sql partition?
What is rownum and rowid?
Explain what is a subquery ?
what is cross join? : Sql dba
How to write pl sql program in mysql command prompt?
What is a recursive stored procedure?
What is the difference between instead of trigger and after trigger?
what is union? : Sql dba
What does select count (*) mean in sql?
What is the difference between having clause and where clause?
