Be careful! Phil wanted the top 20 and the limit 20 will only return a random 20 records.
Regards, Jake Johnson [EMAIL PROTECTED] ______________________________________________________________________ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Mon, 14 Jul 2003, Phil Bitis wrote: > Yeah, put LIMIT 20 on the end. > > ----- Original Message ----- > From: "Jim McAtee" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, July 14, 2003 11:12 PM > Subject: SELECT TOP > > > > What's wrong with the following query? The application used to use Access > via > > ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via MyODBC > 3.51.01. > > > > // Return last 20 searches > > SELECT TOP 20 h.historyid, h.searchstring, h.serverid, s.shortname > > FROM history h > > INNER JOIN servers s ON h.serverid = s.serverid > > WHERE h.employeeid = 9 > > ORDER BY h.historyid DESC > > > > Works fine once I remove the "TOP 20" from the query. If this isn't > supported, > > is there an equivalent? > > > > Thanks, > > Jim > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]