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 is nvl?

1018

What is sql performance tuning?

863

how to fetch common records from two tables? : Sql dba

1104

how to use like conditions? : Sql dba

1036

What does where 1 1 mean in sql?

976

What are all the common sql functions?

968

What is sql constant?

941

What is cold data?

896

Define a temp table?

961

Do we need to create index on primary key?

851

what is the command line end user interface - mysql? : Sql dba

923

How do you concatenate in sql?

971

What are different types of keys?

1013

What is recursive stored procedure?

1045

is it possible to pass an object or table to a procedure as an argument?

1057