Fetch rec

lakshmibala · New User Joined: 16 Jun 2004 Posts: 47

Hi all,

i have a doubet can v retrieve rows frm middle of a table i.e frm 100 to 125 , how is it possible?

Regards
Lakshmi

ConnoisseuR · New User Joined: 06 Aug 2004 Posts: 8 Location: india

Each row in the TABLE is provided with an unique id i.e. TABLE ID.
you can put a simple select query like this:

SELECT *
FROM TABLE_NAME
WHER TABLE_ID BETWEEN 100 AND 500;

Thanks
santosh

lakshmibala · New User Joined: 16 Jun 2004 Posts: 47

HI,

u said the range from 100 to 500, but i am asking 100th row from 500th row ok, r u under stand my question,

regrds
Lakshmi

sandip_datta · Posted: Thu Oct 07, 2004 9:03 am Post subject:

Lakshmi,

I am really confused about the sentence structure of your last post. May be I don't know that much good english. Can you please put some verb in the sentence in proper place and let us know what actually do you want?

Regards,
Sandip.

anuradha · Global Moderator Joined: 06 Jan 2004 Posts: 257

Hi Lakshmi,

ConnoisseuR · New User Joined: 06 Aug 2004 Posts: 8 Location: india

hi lakshmi , i got your problem.this can be done by FETCH FIRST N ROWS

QUERY WILL BE LIKE THIS

SELECT *
FROM TABLE_NAME
WHERE TABLE_ID = 500
FETCH FIRST 100 ROWS ONLY

hope this makes it clear now.

santosh

ConnoisseuR · New User Joined: 06 Aug 2004 Posts: 8 Location: india

hi anuradha,
i would like to correct you that BETWEEN implies including both the boundaries.

so if we write

select *
from table
where field between 100 and 500

this query will process the records including the 100th and 500th.

santosh