select level,max(sal) from emp where level=3 connect by prior sal>sal

Find out the 3rd highest salary?

Question Posted / santosh

Answer Posted / santosh

select level,max(sal) from emp where level=3 connect by
prior sal>sal
group by level;

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Which is faster view or stored procedure?

899

how to convert character strings to numeric values? : Sql dba

1044

What is the size of partition table?

1008

Why do we need a foreign key?

1040

What is the maximum rows in csv?

883

explain the difference between bool, tinyint and bit. : Sql dba

955

What is the max nvarchar size?

915

how to extract a unit value from a date and time? : Sql dba

959

Sql technical questions

1226

Is sql the best database?

937

What is pl sql variable?

956

What are the 3 types of behavioral triggers?

1210

What is 19 null in sql?

919

What is memory optimized?

1035

What are procedures used for?

936