select rowid,[optional columns...] from table where rowid='n';

how u can find the n row from a table?

Question Posted / guest

19 Answers
29290 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / guest

select rowid,[optional columns...] from table where
rowid='n';
--n would be the input from the user which will let you
identify the row number of that particular record

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which is faster joins or subqueries?

974

what happens if you no create privilege in a database? : Sql dba

983

How subquery works in sql?

1054

How to select 10 records from a table?

1144

Explian rowid, rownum?

998

What is left join example?

936

what is the difference between inner and outer join? Explain with example. : Sql dba

1014

How does pl sql work?

952

What is time based sql injection?

944

What is sql lookup?

908

How do I make sql search faster?

982

What is difference between stored procedures and application procedures?

1001

What are instead of triggers?

1030

What is server name sql?

1125

Can you join views in sql?

943