Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Dec 8th, 2011

 

Could you expand a little more on the question a little bit more please. I understand that you have two tables, A and B, but... ok so what, are they related? do you want the data filtered for records on each one? What do you mean by "My records in this table are in such a way that Table A Table B 10 15 11 16 12 10 13 11"? That doesnt make sense.

narendar

• Mar 21st, 2012

 

For example to retrieve 5th to 10th rows in a table emp

select * from ( select A.*, rowid as R from emp A)
where R>=5 and R<=10

SivaKumar

• Mar 23rd, 2012

 

Method 1

Code
SELECT a,employee_id,last_name,first_name,salary FROM


(SELECT ROWNUM AS a,employee_id,last_name,first_name,salary FROM employees)


WHERE a BETWEEN 10 AND 11

hussain

• Mar 29th, 2012

 

Code
SELECT * FROM emp WHERE (rowed,0) IN (SELECT rowid,mod(rownum,5) FROM emp);