select min(sal) from emp where sal in (select sal from emp order by sal de

find the third highest salary?

Question Posted / mousumi dalai

Answer Posted / mousumi dalai

select min(sal) from emp where sal in
(select sal from emp order by sal desc where ROWCOUNT <=3) ;

Is This Answer Correct ?

9 Yes

36 No

Please Help Members By Posting Answers For Below Questions

Does varchar need length?

933

what is data integrity? : Sql dba

988

Explain what is table in a database?

1009

What are joins in sql?

957

What is benefit of creating memory optimized table?

910

How do you pronounce sql?

957

What are different types of sql commands?

1026

What is %type in pl sql?

926

Show the two pl/sql cursor exceptions.

1110

What is a recursive stored procedure?

1098

What does the base_object_type column shows in the user.triggers data dictionary view?

1000

What is view explain with example?

887

What is native sql query?

972

What are the parts of a basic sql query?

920

Should I use mbr or gpt?

950