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 dbms? : Sql dba

1057

what is bcp? When does it used? : Sql dba

1051

If a cursor is open, how can we find in a pl/sql block?

1235

Is primary key always clustered index?

1090

Can we rollback truncate?

1072

what are the advantages of sql ? : Sql dba

1136

How do I remove duplicates in two columns?

1177

how to use regular expression in pattern match conditions? : Sql dba

1105

What is your daily office routine?

2340

Is primary key clustered index?

1011

Can we use distinct and group by together?

1129

how many tables will create when we create table, what are they? : Sql dba

1138

Does group by remove duplicates?

1108

What is the current version of sql?

1091

Is inner join faster than left join?

1273