Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL to retrieve maximum value from a row.
Message
From
17/12/1999 04:42:21
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00305138
Message ID:
00305145
Views:
20
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
Previous
Reply
Map
View

Click here to load this message in the networking platform