Forum Moderators: open

Message Too Old, No Replies

limit records?

         

jimberland

12:48 pm on Jun 29, 2007 (gmt 0)

10+ Year Member



if i had 50 records in a database, how would i return 5 records ordered by date, but not actually display the first record?
thanks

Rebrandt

2:59 pm on Jun 29, 2007 (gmt 0)

10+ Year Member




SELECT * FROM table ORDER BY date_column LIMIT 1,4

jimberland

5:12 pm on Jun 29, 2007 (gmt 0)

10+ Year Member



thank you.