Help SQL command COUNT in existing command

[alexas545]

Hi,

 

I want to count all points from table character_raid_points for same charId

 

Example: I have 100 records for charID: 11111 and in every records has different int points for kill RB.

 

So I need to COUNT all RBs points per charId
 

"SELECT characters.char_name,character_raid_points.charId, character_raid_points.points FROM character_raid_points, characters WHERE character_raid_points.points AND characters.charId = character_raid_points.charId ORDER BY points DESC LIMIT 10;"

This command now generate CharId and points pet one row ( i mean per one kill RB )  - so Need to count all to one INT
 

Edited January 11, 2023 by Vision

[wongerlt]

Group it by char id and select like sum(character_raid_points.*) as scores and join char table to select char name

[alexas545]

On 11/21/2022 at 12:35 AM, wongerlt said:

Group it by char id and select like sum(character_raid_points.*) as scores and join char table to select char name

Thank you, already done