Get 10 and 11th records in the output using SQL in 5 ways ?

I have to tables A and B. My records in this table are in such a way that
Table A Table B
10 15
11 16
12 10
13 11
Question :- I want only the 10 and 11 records as my output.
Can anyone help me out ( 5 ways to get this output )

kalyan.sam
Profile Answers by kalyan.sam Questions by kalyan.sam
Dec 5th, 2011
4
11794

Questions by kalyan.sam

SQL

Answer

Showing Answers 1 - 4 of 4 Answers

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