Select rows X-to Y

[tommot82]

Is there an easy way of returning specified rows that have no index column?

I basically want to create a queries that only returns rows in blocks of 20 for example.

any ideas?

 

[tommot82]

to clarify i want a rolling range of 20 after i have ordered the rows.

 

[r937]

whether or not a table has any indexes is irrelevant to the query which you need to write to return the data that you want

indexes can, however, make the query perform efficiently

do a search for "paging +postgresql" or "paging +mysql" or "paging +msaccess" or whatever your database system is

you're not likely to get the answer you need in the ANSI SQL forum

r937.com | rudy.ca

 

[tommot82]

ok thanks