Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118303 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / rajesh.m
Crete Table Curtest(Emp char(40),salary money)
------------------------------------------------
Select Min(Salary) from Curtest where Salary
in (select Top 2 Salary from Curtest)
--------------------------------------------------
| Is This Answer Correct ? | 21 Yes | 33 No |
Post New Answer View All Answers
Which is faster truncate or drop?
what is the difference between inner and outer join? Explain with example. : Sql dba
Is hadoop a nosql?
What does bitemporal mean?
How to add new employee details in an employee_details table with the following details
Is sql an operating system?
What is the difference between drop and truncate commands?
Can we create foreign key without primary key?
How do you write a subquery?
How do I add a primary key to a table?
What is optimistic concurrency control? : Transact sql
What is right join in sql?
what is table? : Sql dba
Which sql statement is used to delete data from a database?
what is row? : Sql dba
