Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102347 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / kotravel. b
SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
THIS will surly give 2^nd max sal ok this correct ans ok....
| Is This Answer Correct ? | 85 Yes | 13 No |
Post New Answer View All Answers
What is auto increment?
How can we make an if statement within a select statement?
What is normalization sql?
What is the difference between partition and index?
What is ttitle and btitle?
How do you know if a relationship is 2nf?
Which is faster truncate or drop?
How do I copy a table in sql?
what is dbms? : Sql dba
what is a constraint? : Sql dba
What are different sql data types?
What is flag in sql?
explain advantages of myisam over innodb? : Sql dba
Is natural join same as inner join?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
