Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select max ????
Message
From
06/03/2003 14:48:43
 
 
To
06/03/2003 14:44:40
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00762387
Message ID:
00762390
Views:
16
SELECT MAX(FIELDNAME) from mytable INTO CURSOR MYCURSOR

or

select groupfield, max(fieldname) from mytable group by groupfield into cursor mycursor

pf

>Ok i have a field in a database. The type of this field is an integer
>
>i want to make obtain the bigger number with a select
>
>how ?

(On an infant's shirt): Already smarter than Bush
Previous
Reply
Map
View

Click here to load this message in the networking platform