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 find no of saturdays in a month using single sql ?
how to find out largest value in a table
What is a recycle bin in oracle?
What are the different types of trigger and explain its various uses and functions?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
What a SELECT FOR UPDATE cursor represent.?
What is the quickest way to export a table to a flat file?
How to drop a stored procedure in oracle?
How to export your own schema?
How to find out what oracle odbc drivers are installed?
What is a synonym? What are its various types?
What is an Oracle sequence?