it's easy with self join: select max(sal) from emp e1,emp e2 where e1

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

Question Posted / babbu

Answer Posted / babbu

it's easy with self join:
select max(sal) from emp e1,emp e2 where e1.sal < e2.sal

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is recursive join in sql?

948

What are crud methods?

971

what are myisam tables? : Sql dba

956

What is pl sql package?

993

What is the least restrictive isolation level? : Transact sql

999

What is the difference between delete and truncate commands?

979

what is commit? : Sql dba

1029

What is user in sql?

970

What is difference between pls_integer and integer?

910

how to calculate the difference between two dates? : Sql dba

996

How do sql databases work?

947

Why is normalization important?

973

What is a sql*loader control file?

1165

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1067

how many ways we can we find the current date using mysql? : Sql dba

1039