Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118096 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
how can you see all indexes defined for a table? : Sql dba
What can sql server reporting services do?
What is the maximum number of columns in sql table?
When to use inner join and left join?
When do we use triggers?
How do you break a loop in pl sql?
Can we create foreign key without primary key?
What is the difference between function and procedure in pl/sql?
What is the difference between pl and sql?
What is the difference between database trigger and stored procedure?
What is the difference between python and sql?
What is use of trigger?
How do I audit the sql sent to the server?
What is java sql package?
Does sqlite need a server?
