function sum multiple columns in sql

Question

`statistiques` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`pag_id` INT(11) NULL DEFAULT NULL,
`likes` VARCHAR(45) NULL DEFAULT NULL,
`comments` VARCHAR(45) NULL DEFAULT NULL,
`likepost` VARCHAR(45) NULL DEFAULT NULL,
`posts` VARCHAR(45) NULL DEFAULT NULL,
`talk` VARCHAR(45) NULL DEFAULT NULL,
`char` VARCHAR(50) NULL DEFAULT NULL,
`engagement` VARCHAR(50) NULL DEFAULT '0',
`created` DATE NULL DEFAULT NULL,
PRIMARY KEY (`id`),

and i have data in table i went to do this query for sum chemps in my table

select sum(likes) from statistiques where pag_id in (12,20) and created="2013-12-02"

but i went have multiple sum like

select sum(likes,posts) from statistiques where pag_id in (12,20) and created="2013-12-02"

but he isn't worked

English is not my native language, sorry for any mistakes.

OldProgrammer · Accepted Answer · 2013-12-19 19:01:46Z

2

Your syntax is wrong. Try

select sum(likes), sum(posts) from ...

answered Dec 19, 2013 at 19:01

OldProgrammer

12.2k4 gold badges27 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

function sum multiple columns in sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related