Steve, Doug & Gordan,
Thanks for taking the time to help me.
Billy
- Original Message -
From: "Steve Rapaport" <[EMAIL PROTECTED]>
To: "Billy Reed" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, December 28, 2001 2:17 AM
Subject: Re:
Instead of TOP 5 DistKm FROM SCLeague
you can probably use
DistKm SORTED BY DistKm DESCENDING LIMIT 5
The rest about temp files is probably best to read
Goran Bobic's mail.
Billy Reed wrote:
> I am new to MySQL and am trying to convert :
>
> SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5
On Thursday 27 Dec 2001 23:31, Billy Reed wrote:
> I am new to MySQL and am trying to convert :
>
> SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5 DistKm FROM XCLeague
> WHERE LoginID='billyreed' AND HGPG='PG' ORDER BY DistKm DESC)
>
> Can anyone suggest how this is done in MySQL. It doesnt see
I am new to MySQL and am trying to convert :
SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5 DistKm FROM XCLeague WHERE
LoginID='billyreed' AND HGPG='PG' ORDER BY DistKm DESC)
This is a subselect which selects the top 5 cross country flight distances
of hang glider pilots (for a specific pilot
