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

how u can find the n row from a table?

Question Posted / guest

19 Answers
29511 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

Can we create table inside stored procedure?

955

How do I upgrade sql?

998

What are the triggers associated with image items?

1042

What are the operators used in select statements?

1058

How do I find duplicates in sql?

929

What is rollback?

1115

Explain the the update statement in sql?

1036

What is a schema sql?

1152

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3569

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1145

What is rtm stands for?

1098

Can we use insert statement in function?

1000

Where the sql database files are stored?

1014

Does access use sql?

1040

Explain cursor types?

1026