Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL to retrieve maximum value from a row.
Message
De
17/12/1999 04:42:21
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00305138
Message ID:
00305145
Vues:
19
Martin,

You can use the max() function of visual foxpro to determine which of your express is the maximum one.

Try to make a prg example nmax.prg and from it, you can now make SQL statement to determine which one is maximum.

SELECT nmax(a.one,a.two,a.three,a.four) AS maxvalue FROM one a INTO CURSOR sample

*************
* NMAX.PRG
**************
PARAMETER one,two,three,four
nmax=MAX(one,two,three,four)
RETURN nmax


REYMUNDO A.ESCOTE
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform