select rownum, empno, ename from emp where rowid in (select rowid from emp

Display the records between two range?

Question Posted / nishi

Answer Posted / nishi

select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum<&Start);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create a new view in oracle?

680

What privilege is needed for a user to query tables in another schema?

563

What do you mean by redo log file mirroring?

612

What does sharding mean?

611

What is a parameter file in oracle?

618

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1536

How does Oracle guarantee data integrity of data changes?

1990

How to delete multiple rows from a table in oracle?

620

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

2805

how to join query for one source type is oracle another source type is sql server ?

2058

How to define an oracle sub procedure?

659

What is the difference between substr and instr?

575

How to drop a tablespace?

634

Explain about achiever in sql?

638

Can we write dml statement in function in oracle?

692