select * from(select rownum r,column name,from table name) where r=&n;

how u can find the n row from a table?

Question Posted / a.brahmam

Answer Posted / a.brahmam

select * from(select rownum r,column name,from table name)
where r=&n;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how does a local variable is defined using t-sql? : Transact sql

550

How is debugging done?

537

Is pl sql a scripting language?

595

When are we going to use truncate and delete?

555

Is drop table faster than truncate?

559

Which one is faster ienumerable or iqueryable?

491

What is example of database?

519

What are the built in functions of sql?

573

How does sql developer connect to oracle database?

530

how to select first 5 records from a table? : Sql dba

516

What is mutating error in pl sql?

557

Is record in pl sql?

521

What is the use of procedures?

550

What is a relationship and what are they?

585

What is before trigger?

558