Re: SELECT TOP

[Eternal Designs, Inc]

Sure Woody and Phil are right; just take out TOP 20 and put LIMIT 20 at 
the end of your SQL. If you care for the docs, the page is at 
http://www.mysql.com/doc/en/SELECT.html

Peter
Eternal Designs
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]