General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
thanks for all your answers. I just got here and quickly tried this and worked.
Select Name, Max(Score) from myCur where Id = Id into cursor whatever
group by Name
It gives me all I need, the highest score for each person.
thanks again
Previous
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