Help is needed in setting an interval
Posted 10 June 2003 - 08:09 PM
THere\'s a table with say 5 columns and 60 rows. How can i make a SELECT query, that selects the rows between 20 and 30? (there are id-s in every rows, but as some are usually deleted, it cannot be said, that rows between the id-s 20 and 30) I know, that there\'s a phrase called \'BETWEEN\', but dunno how may i apply it when talkin about rows...
Posted 11 June 2003 - 12:30 PM
However, recently I\'ve heard that all rows should be processed, and in the array just the surplus should be deleted... What do you think?
Thanks for the answers:
Posted 11 June 2003 - 12:42 PM
SELECT * FROM table ORDER BY id LIMIT 10 OFFSET 20;
will return 10 records starting from record number 20...
Posted 11 June 2003 - 01:10 PM
Will try that!
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users