how u can find the n row from a table?

Answer Posted / rashmi

select max(rownum) from table1 where rowid is not null

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are sql * plus commands?

548


What are aggregate and scalar functions?

536


What mean sql?

589


What is a primary key? Explain

553


What is trigger in sql and its types?

545






What is the use of %rowtype?

547


What is the process of copying data from table a to table b?

604


Does a user_objects view have an entry for a trigger?

577


How many types of literals are available in pl sql?

526


Can a view be mutating? If yes, then how?

586


How can you tell the difference between an index and a view?

504


how to create a new table by selecting rows from another table in mysql? : Sql dba

572


What are sql triggers used for?

519


What is sql data?

558


what is rdbms? : Sql dba

588