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 convert times to characters in oracle?
What are a cluster and non-cluster index?
Explain an index?
what are stored procedures?
How many file formats are supported to export data?
In what script is snap$ created? In what script is the scott/tiger schema created?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
What is the usage of save points in oracle database?
How to build data dictionary view an new database?
How a database is related to tablespaces?
Explain an exception and its types?
How to write text literals in oracle?