Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116220 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 the advantages of stored procedure?
What is trigger point?
Can you have more than one key in a database?
What type of database is sql?
Explain how can you save or place your msg in a table?
How to write pl sql program in mysql command prompt?
How to test for null values?
how can we destroy the cookie? : Sql dba
What is the reports view in oracle sql developer?
How to run sql statements with oracle sql developer?
What is right join sql?
How many databases can sql express handle?
What is prepared statement in sql?
Why do we need pl sql?
What are the properties of a transaction?
