Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120172 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
What are dml commands?
define sql insert statement ? : Sql dba
what is the difference between inner and outer join? Explain with example. : Sql dba
What are the advantages of pl sql?
How do you explain an index?
What is pl sql package?
what are date and time data types in mysql? : Sql dba
What is a temporal table?
Determine if oracle date is on a weekend?
What is a table partition?
What is nested table in pl sql?
Can sql function call stored procedure?
Explain spool.
What are stored procedures in mysql?
What are sql commands?
