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 do we create privileges in oracle?
How to use "in" parameter properly?
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is forall Statement ?
What are the different types of failures that occur in Oracle database?
What is oracle analytical function?
What is difference between sid and service name in oracle?
What is an oracle table?
How to bring a tablespace online?
what is the difference between no rows returned and null returned?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,