dBforums - View Single Post - How to limit records

#2 (permalink)

11-29-08, 05:49

mike_bike_kite mike_bike_kite is offline

vaguely human

Join Date: Jun 2007

Location: London

Posts: 2,517

Code:

SELECT distinct t1.ID_TOPIC, t1.subject
FROM messages AS t1
ORDER BY t1.posterTime DESC
LIMIT 10

Mike