how to find 5th row ?

Answer Posted / sanket.infy

select * from table t1 where rownum = 5 ;

Is This Answer Correct ?    1 Yes 31 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is offset in sql query?

598


what is clause? : Sql dba

601


How to start oracle sql developer?

566


Can we create a trigger on view?

496


Can you call pl/sql package functions from within a fast formula?

574






Is oracle sql free?

549


How do I pipe the output of one isql to another?

536


What is difference between stored function and application function?

601


What is %s in sql?

575


Show the two pl/sql cursor exceptions.

622


What is the difference between a subquery and a join?

534


What is mutating error in pl sql?

557


does sql support programming? : Sql dba

613


What is the use of count (*) in sql?

553


How do I view tables in sql developer?

518