DISTINCT not working inside a CASE statement.

u have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DISTINCT sum) THEN sum(cost) ELSE NULL END AS cost_sum from prices group by name' at line 1 -- ==== Regards, Arup Rakshit De

Re: DISTINCT not working inside a CASE statement.

roup by name; +--+--+ | name | cost_sum | +--+--+ | A| 6700 | | B|12000 | | C| NULL | +--+--+ 3 rows in set (0.01 sec) Thanks. -- Regards, Arup Rakshit Debugging is twice as hard as writing the code in the first place. There