Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118063 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / sandip
SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
I don't think this will work correct me if i am
wrong.Correct one is-------
SELECT MAX(SAL) as SAL FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between null value, zero, and blank space?
What are the different types of constraints?
Is sql better than access?
What is the need of merge statement?
What are tuples in sql?
What does closing a cursor do?
What is embedded sql with example?
What's the difference between a primary key and a clustered index?
Explain autonomous transaction.
How do I find duplicates in sql?
Which is faster joins or subqueries?
What is meaning of <> in sql?
What is blind sql injection?
Which join is default?
How many columns should be in an index?
