select max(sal) from table where level=5 connect by prior sal>sal;

how to find the fifth highest salary?

Question Posted / soumen saha

Answer Posted / soumen saha

select max(sal) from table where level=5 connect by prior
sal>sal;

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a Relation Schema and a Relation?

909

Explain the microsoft sql server delete command? : sql server architect

806

Explain logical database components? : sql server architect

765

What is internal database?

988

How is the data structure of System R different from the relational structure?

835

What is degree of Relationship type?

851

What is database architecture?

704

What is 2 tier 3 tier architecture?

848

What is msdb database? : sql server architect

983

What is difference between two tier and three tier?

859

Do you know what the restrictions applicable while creating views are? : sql server architect

788

What is Query evaluation engine?

951

What is database architecture? : sql server architect

891

What is E-R model?

888

When is a functional dependency F said to be minimal?

784