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 calculate date and time differences in oracle?
How to enter a new row into a table interactively?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is an Index Segment ?
What do you mean by merge in oracle and how can you merge two tables?
How to list all tables in your schema?
what is the difference between sql& oracle?
What is a user account in oracle?
What are the differences between interval year to month and interval day to second?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What is the meaning of recursive hints in oracle?
what are actual and formal parameters?