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 Mo

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, Gabr

Re: SELECT TOP

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

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 >

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 fi

Re: SELECT TOP

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

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 h

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 >

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

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 fi

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