Код:
SELECT TOP 1000 CharacterName, Point
+ coalesce
((SELECT sum(Point)
FROM EVENT_INFO2008
WHERE EVENT_INFO2008.CharacterName=EVENT_INFO.CharacterName),0)
+coalesce
((SELECT sum(Point)
FROM EVENT_INFO2009
WHERE EVENT_INFO2009.CharacterName=EVENT_INFO.CharacterName),0)
AS sumPoints
FROM EVENT_INFO WHERE CharacterName='Fine'
ORDER BY sumPoints DESC
Ако това изкара 4 резултата на героя Fine как тяхните Point да се сумират и да изкара само 1 резултат с общия брой на 4-те резултата?