Help : CASE statement in Query designer - SQL

SQL
CASE statement in Query designer - SQL

CASE statement in Query designer - SQL

 

SELECT

Categorie,

UserID,

                (

                CASE

                               WHEN BedragPmnd<0 THEN

                               BedragPmnd *-1

                               ELSE BedragPmnd

                END) AS total

 

 

FROM Begroting

GROUP BY Categorie, UserID

HELP | filter eenvoudig op categorie

made by: GreenApples