Display the records between two range?
Answers were Sorted based on User's Feedback
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 |
Answer / basanti
select * from emp where emp_id between '200' and '300'
Is This Answer Correct ? | 0 Yes | 0 No |
How to create a new view in oracle?
What is an oracle recycle bin?
What is a Data File ?
How can we find out the duplicate values in an oracle table?
How to get a list of all user accounts in the database?
Difference between varchar and varchar2 data types?
What is a cluster?
How do you tell what your machine name is and what is its IP address?
what are the advantages of running a database in NO archive log mode?
what diffrence between function and procedure?
How to create a new oracle data file?
What is materialized view in Oracle?