SELECT with LIMIT
| From: | afan | Date: | Sat, 06 Jan 2001 01:19:22 +0000 |
| Subject: | SELECT with LIMIT | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-4840@lists.php.net to get a copy of this message | ||
Hi all,
With
SELECT * FROM table_name LIMIT 0,158
I'm puling out from table first 158 elements.
But what about if I want to pull out last 158 elements from table?
Solution:
SELECT * FROM table_name LIMIT 0,158 ORDER BY id DESC
doesn't work.
Thanks!
Afan