select min(sal) from (Select sal FROM emp where rownum<=3 Order by

Find out the 3rd highest salary?

Question Posted / shaiju nair

Answer Posted / shaiju nair

select min(sal) from (Select sal
FROM emp where rownum<=3
Order by sal desc)

Is This Answer Correct ?

13 Yes

25 No

Please Help Members By Posting Answers For Below Questions

What are the set operators in sql?

1027

What is a boolean in sql?

943

What is difference between sql function and stored procedure?

941

Why do we use joins?

983

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1025

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

955

What is the difference between clustered and non-clustered index in sql?

957

Explain the insert into statements in sql?

935

Enlist some predefined exceptions?

993

What sql database should I use?

1071

What is sql*loader and what is it used for?

1044

How to read/write files from pl/sql?

991

Can you do multiple joins in sql?

970

Is left join and outer join same?

1001

what happens if you no create privilege in a database? : Sql dba

938