select max(sal) from emp where sal<(select max(sal) from emp where sal&l

how to check the 3rd max salary from an employee table?

Question Posted / amit

Answer Posted / amit

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are all different types of collation sensitivity?

1043

What are the types of join and explain each?

1059

What are pl sql procedures?

1033

discuss about myisam index statistics collection. : Sql dba

960

What will you get by the cursor attribute sql%rowcount?

1046

Explain the the update statement in sql?

1051

How many sql databases can you have on one server?

1095

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1212

Is sql a microsoft product?

955

What's the difference between inner join and left join?

1008

How do you explain an index number?

1116

how to shutdown mysql server? : Sql dba

1110

What is group function in sql?

1028

What is thread join () in threading?

1019

Can we create table in function?

973