select a2.* from (select rownum r,a1.* from a a1)a2 where a2.r=&An

how u can find the n row from a table?

Question Posted / manoj gogoi

Answer Posted / manoj gogoi

select a2.*
from
(select rownum r,a1.* from a a1)a2
where a2.r=&Any_Row_U_Want

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is use of package in pl sql?

534

Can a trigger call a stored procedure?

541

What is data type in database?

550

How does join work in sql?

556

What is a natural join?

518

what are properties of a transaction? : Sql dba

563

What are the packages in pl sql?

579

Do we need to rebuild index after truncate?

529

What is graph sql?

528

Explain the difference between rename and alias?

545

What are pl/sql cursors?

567

what is rollback? : Sql dba

597

Enlist the data types that can be used in pl/sql?

577

What is integrity in sql?

562

How do you select unique values in sql?

504