Ucretsiz Kucuk Boyutlu Programlar Yazilir (2. sayfa)

SELECT DISTINCT( Name ),  
                 Max(Level),  
                 Class,  
                 Sum(Kills),  
                 Sum(Deaths),  
                 Sum(Points),  
                 Sum(TotalTime),  
                 Sum(TotalVisits),  
                 CharacterID  
  FROM   Characters  
  WHERE  Name LIKE '$value%'  
          OR CharacterID LIKE '$value'  
  ORDER  BY Name ASC; 

SELECT 
    name, 
    MAX(Level), 
    Class, 
    SUM(Kills), 
    SUM(Deaths), 
    SUM(Points), 
    SUM(TotalTime), 
    SUM(TotalVisits), 
    CharacterID 
  FROM 
    Characters 
  WHERE 
    Name LIKE '$value%' OR CharacterID LIKE '$value' 
  GROUP BY 
    name, 
    class, 
    characterid 
  ORDER BY 
    Name ASC 
  ;