how u can find the n row from a table?

Answer Posted / manish singhania

select * from emp where rownum<=n
minus
select * from emp where rownum<n

n=1,2,......so many

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we implement rollback or commit statement in a trigger?

567


What is where clause in sql?

524


What is Collation Sensitivity ? What are the various type ?

490


How do I enable sql encryption?

512


When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

618






what are the different index configurations a table can have? : Sql dba

562


What are instead of triggers?

611


How does an execution block start and end in pl sql?

491


What is basic structure of pl sql?

490


What is online transaction processing (oltp)?

598


What do you understand by case manipulation functions?

539


How is debugging done?

523


What are the qualities of 2nf?

536


what is a composite primary key ? : Sql dba

574


What is the difference between stored procedure and view?

524