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 are the 3 levels of data abstraction?

788

Explain about recursive stored procedures?

742

What is a view? How it is related to data independence?

834

Brief theory of Network, Hierarchical schemas and their properties

782

Explain logical database components? : sql server architect

713

What are page splits? : sql server architect

837

What is tier in database?

756

What is n tier architecture with example?

700

What is external database?

814

What is E-R model?

821

What is difference between 2 tier and 3 tier architecture?

730

What is a Database system?

805

What is System R? What are its two major subsystems?

745

What is a query?

814

What is the job of the information stored in data-dictionary?

760