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
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
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" <
> 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 server
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
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 Per
SELECT 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 limit 20;
^
You probably mean LIMIT to limit.
On Mon, 2003-07-14 at 17:12, Jim McAtee w
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,
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 li
