select a slice of records from a position

[skneife]

I need to get a range of records from a specific position like Limit
start,numberOfRecords in mySql:
Example a table with columns name and age:
id name age
1 John 20
2 Peter 31
3 Mike 18
....
150 Andrew 45

Now I need to get a slice of records that return at position 3 the 10
next records.
" is the stared position and 10 the slice needed.
Is there a simple way for soing that ?

Sam

 

[Guest]

Sam,

In a relational database table, the order of the rows (as well as the
columns) MUST be immaterial to any application using the data.

You need to find a way to retrieve the data you need, based on the DATA, not
its position within the table.

Kerry Moorman