Display the records between two range?

Question Posted / nishi

Answers were Sorted based on User's Feedback

Display the records between two range?..

Answer / 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

Display the records between two range?..

Answer / basanti

select * from emp where emp_id between '200' and '300'

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

Difference between primary key and unique key ?

What suggestions do you have to reduce the network traffic?

Can we call a trigger inside a function and function inside a trigger? Give example.

What is background process in Oracle?

how to use sequence and what use of sequence cache

What is a subquery in oracle?

What is meant by joins? List out the types of joins.

How to view the data files in the current database?

How do you rate yourself in oracle and sql server ?

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

what is IDE,DMV in sql server?

What is a synonym? What are its various types?

For more Oracle General Interview Questions Click Here