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: MS Access to MySQL convert
Instead of TOP 5
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
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 seem to