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 are the three forms of normalization?

1045

how is myisam table stored? : Sql dba

1057

What is sql in java?

1090

what are the different type of normalization? : Sql dba

1027

Explain the methods used to protect source code of pl/sql.

1020

what is a database lock ? : Sql dba

1173

What are properties of the transaction?

998

Describe different types of general function used in sql?

1038

What is implicit cursor in pl sql?

1095

How do I view a sql trace file?

1031

Why are sql stored procedures used?

1057

What does partition by mean in sql?

963

How do you break a loop in pl sql?

1050

Is left join same as join?

997

Can we use loop in sql?

970