MySQL Hosting : How to limit records

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by Frunkie 0n 29 November 2008

Admittedly I haven’t been using much database code lately and something that I think I would have been able to handle on my own before, has me stumped today.

What I need are the 10 latest records, differentiated by a UNIX timestamp column (t1.posterTime).

This is the code as I thought it should be. I get correct results when I remove the GROUP BY but then get dupe rows. What I need are all distinct rows and then order them by the latest UNIX stamp. Easy I know, but I’m stuck. Should I be using a self join for this?

Learn more about MySQL databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting