Display the records between two range?
- 2 Answers
- 3073 Views
- I also Faced
- E-Mail Answers
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 |
what are pseudocolumns?
How do I escape a reserved word in oracle?
What is recycle bin in Oracle?
Explain compound trigger in oracle?
Why we use bulk collect in oracle?
Does oracle charge for java?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
How do I connect to oracle?
What are the different types of database objects?
Explain the different normalization forms?
How to drop a stored function?
Oracle General 
