inserting if in a select query

Question

How can i do something like this ? ``` SELECT (IF(SUM(Costo) > 0) SUM(Costo) ELSE 0) AS Expr1 FROM TDP_NotaSpeseSezB ```

Accepted Answer

You want to use a CASE statement.

```
Select 
  CASE WHEN SUM(Costo) > 0 THEN SUM(Costo) 
  ELSE 0 
  END 'Expr1'
FROM
  TDP_NotaSpeseSezB
```

Solution