Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102881 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
In a distributed database system, can we execute two queries simultaneously?
Which are sql * plus commands?
What are the different sql commands?
What is composite primary key in sql?
What is the life of an sql statement?
What is integrity in sql?
What is sqlcommand?
What is native sql query?
What is the use of pl/sql table?
What do we need to check in database testing?
Explian rowid, rownum?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is cold data?
What is normalization sql?
