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

What is the difference between truncate and drop statements?

575


What is the current version of postgresql?

554


what is 'mysqlimport'? : Sql dba

572


How do you remove duplicate records from a table?

511


How do you optimize a stored procedure query?

566






Explain autonomous transaction.

636


Is vs as in pl sql?

492


What is nosql db?

543


What is trigger price?

539


What is scalar data type in pl sql?

553


How to download oracle sql developer?

661


What are the differences between implicit and explicit cursors?

517


Define commit?

548


what is the difference between cluster and non cluster index? : Sql dba

554


What is rollback?

581