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

Find out the 3rd highest salary?

Question Posted / divya c

Answer Posted / divya c

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is it possible to create the following trigger: before or after update trigger for each row?

1272

How insert into statements in sql?

1056

What are different types of statements supported by sql?

1144

What is percent sign in sql?

1260

how to create a new table in mysql? : Sql dba

968

what is rdbms? : Sql dba

997

what is the stuff function and how does it differ from the replace function? : Sql dba

1027

Is big data nosql?

922

What is varchar example?

1011

Is sql database free?

957

Is there a way to automate sql execution from the command-line, batch job or shell script?

953

Why do we use joins in sql?

956

What is the difference between inner join and natural join?

988

explain about mysql and its features. : Sql dba

1000

What are the dml statements?

1129