General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>It'll give you MIN(Numero) for each group but the rest of the fields in the record, that are not in group by clause, will come from the last physical record in the group which may or may not be the record with MIN(Numero).
Don't forget that VFP8 will not allow queries like this. Everything that is not an aggregate field (SUM(), TOP(), etc.) that is in the SELECT clause must be included in the GROUP BY clause. It looks like your other solution is what Michel really needs since he needs the whole record that has the minumum value in a particular field.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only