Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select top 3 within a group
Message
From
18/06/2006 00:48:39
 
 
To
16/06/2006 20:48:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01129690
Message ID:
01129782
Views:
24
According to the way of thinking of Sergey,I write it in VFP8
SELECT B.Team,B.Score ;
	FROM mytable A INNER JOIN mytable B ;
          ON A.Team = B.Team ;
	 AND A.Score => B.Score;
        GROUP BY B.Team,B.Score	;
	HAVING COUNT(*) <= 3 ;
	ORDER BY B.Team,B.Score Desc
ZhiGang Yuan
MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform