>>Is there any way using one select statement get as result a top, let's say 10
>>MAX() values from field ?
>If I understand you right,
>SELECT TOP 10 * FROM myTable ORDER BY myField DESC
>should do it.
One 'strange' thing about VFP SQL: this will give you the top 10 values, as you asked for. However, if these 10 values occur in 100 records...