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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.