Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102873 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);
The 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 view means?
What is mutating sql table?
Why we use join in sql?
Is sql difficult?
Can sql developer connect to db2?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How do you write an index?
how can we destroy the cookie? : Sql dba
What is raid? How does it help storage of databases?
Explain clause in sql?
What is trigger with example?
what is a composite primary key ? : Sql dba
Explain mutating table error.
What is input buffer in sql*plus?
what is the stuff function and how does it differ from the replace function? : Sql dba
