most populer query ?

[Fenerbahce]

table : kisiler
name surname points
----- -------- ----
ali elli 1
ali elli 5
ali elli 5
veli kollu 3
veli kollu 4
adem bacakli 2
ali elli 4
veli kollu 5

Q ; how can i get result has been showed below;

ali elli 15
veli kollu 12
adem bacakli 2

thanks

[aniseed]

You will have to make use of GROUP BY clause.
http://www.w3schools.com/sql/sql_groupby.asp

I guess it should look like:

SELECT name, surname, sum(points)  FROM kisiler
GROUP BY name, surname

[Fenerbahce]

yes it works but, i want to use order by points desc is well. i can do it. bigest point will be first row, lowest last.

thank you