Toggle navigation
Dashboard
Dashboard Tracker
Add / Edit My Forums
System Announcements
Discussion
Active Thread Feed
Top Threads Today
Top Threads This Week
Top Threads Library
Go!
View All
View All
Login
Logout
Home
Forums Index
Server Side
/
Databases
8:19 am Sep 21, 2026
This page requires javascript.
Forum Moderators:
open
Message Too Old, No Replies
limit records?
jimberland
Msg#:3382043
12:48 pm on Jun 29, 2007
(gmt 0)
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
Msg#:3382128
2:59 pm on Jun 29, 2007
(gmt 0)
SELECT * FROM table ORDER BY date_column LIMIT 1,4
jimberland
Msg#:3382299
5:12 pm on Jun 29, 2007
(gmt 0)
thank you.
Join The Conversation
Register
For Free! -
Become a
Pro Member
!
See forum categories
-
Enter the Forum
Moderators and Top Contributors
Moderator List
| Top Contributors:
This Week
,
This Month
,
Aug
,
Jul
,
Archive
,
Top 100 All Time
,
Top Voted Members
Hot Threads This Week
September 2026 Google Search Observations
AdSense Earnings and Observations - September 2026
An old fashioned desktop WYSIWIG HTML editor
Home
Forums Index
Server Side
/
Databases
8:19 am Sep 21, 2026