SELECT TOP

2003-07-14 Thread Jim McAtee
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

Re: SELECT TOP

2003-07-14 Thread Phil Bitis
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

Re: SELECT TOP

2003-07-14 Thread woody at nfri dot com
wrote: 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

Re: SELECT TOP

2003-07-14 Thread Jake Johnson
, 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

Re: SELECT TOP

2003-07-14 Thread Gabriel Guzman
On Mon, 2003-07-14 at 17:44, Jake Johnson wrote: Be careful! Phil wanted the top 20 and the limit 20 will only return a random 20 records. Actually, LIMIT x will return the first x rows of a query, not random records. In fact, you can even combine ORDER BY and LIMIT if you want to get the

Re: SELECT TOP

2003-07-14 Thread William R. Mussatto
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

Re: SELECT TOP

2003-07-14 Thread Eternal Designs, Inc
[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

Re: SELECT TOP

2003-07-14 Thread Jake Johnson
No kidding. I didn't know that. Thanks a lot! 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,

Re: SELECT TOP

2003-07-14 Thread Eternal Designs, Inc
Jake Johnson wrote: No kidding. I didn't know that. Thanks a lot! Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On

SELECT TOP?

2001-05-11 Thread Anthony Colli
Hi all- I am really new to the list and mysql. Here is my Question. I am used to writing SELECT TOP [num] FROM [table] I have searched the documentation online and found no mention of how to do this. But I did find info on LIMIT that limits the number of records returned. Is this how mysql

Re: SELECT TOP?

2001-05-11 Thread Thalis A. Kalfigopoulos
On Fri, 11 May 2001, Anthony Colli wrote: Hi all- I am really new to the list and mysql. Here is my Question. I am used to writing SELECT TOP [num] FROM [table] I have searched the documentation online and found no mention of how to do this. But I did find info on LIMIT that limits