how u can find the n row from a table?

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

How do I access sql anywhere database?

489


Is left join same as inner join?

529


What is the difference between alter trigger and drop trigger statements?

597


Is there any restriction on the use of union in embedded sql?

663


What is inner join in sql?

578






Is join same as left join?

520


What is recursive stored procedure?

589


What is the use of pl/sql table?

544


What is mutating sql table?

597


What is an exception in pl/sql?

537


Why do we use sqlite?

519


Are there any features that are decommissioned in 11g that are not present in 11g?

1580


What is dba in sql? : SQL DBA

524


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

535


What is an alias command?

566