select max(sal) from emp where sal<(select max(sal) from emp);

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / mallikarjuna

69 Answers
118153 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answer Posted / mallikarjuna

select max(sal) from emp where sal<(select max(sal) from emp);

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the most important ddl statements in sql are?

991

What are the types of join and explain each?

1031

define sql delete statement ? : Sql dba

1012

Is coalesce faster than isnull?

964

Is sql a microsoft product?

944

What is a temporal table?

923

How to pronounce postgresql?

1055

how to create a new table by selecting rows from another table in mysql? : Sql dba

1083

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1145

What is the use of & in pl sql?

1038

What does the sign mean in sql?

984

How many joins in sql?

1002

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1025

Explain the advantages and disadvantages of stored procedure?

1141

how to concatenate two character strings? : Sql dba

1093