LIMIT ? - How to limit number of returned records..
Posted on 1998-09-15
How do i limit the number of returned records.
Eg. Imagine I wish to get the first record->tenth records returned only.
And later on I want the thirty-first record-> forty'th records returned...
I saw some SQL like this ..
".... WHERE artist like 'a%' order by artist limit 0,100 "
See that "limit 0,100...". I thought this means sow 0->100 records only..
But i get an error when i try to do that in my SQL..
Sorry about the meagre points - this is all i have left...