How can I get a unique sorted list?

[Steven Ronald]

Ruslan,

I have a table with two fields eg:

ID   points
4        455
2        343
4        888
9      1023


It is possible to have multiple records with the same
ID number but different points.

I want to get a list of those with the highest number
of points. For the above table this would be

ID    points
9      1023
4        888
2        343

However if I do cursorRef=select(ID,points from table
ORDER BY points Desc) I will get

ID     points
9      1023
4      888
4      455
2      343

I want to avoid the duplicates and just select the
highest number of points for each ID.

Is there a way to do this within Valentina (V4WS)?

Best Regards,
Steven


	

	
		
____________________________________________________ 
On Yahoo!7 
Messenger: Plug-in the fun with handy plug-ins 
http://au.messenger.yahoo.com