I believe you've answered yourself in your subject. It's called LIMIT in mysql, and it's slightly more flexible than using TOP.
SELECT Airdates.ShowID FROM shows LIMIT 30; shows only the first 30 records returned from the query. SELECT Airdates.ShowID FROM shows LIMIT 10,30; shows records 10 through 40. --min http://www.intrafoundation.com > Using a mySQL Database with thousands of records. > For the query below, > to optimize performance, I'd like to be able to > return on the TOP N records. > > A. "SELECT TOP 50" doesn't work in mySQL. "Top" is > only SQL > Server, correct? > B. "From Shows Limit 50" returns an error as well. > > 1. What's the equal of "TOP" in mySQL? > 2. At what point in the query is that actually > evaluated? > I don't want the first 50 records, I want the > first > TOP records out of all of them according to the > sort. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223082 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
