Home » SQL – Sum of positive and negative numbers without subquery

# SQL – Sum of positive and negative numbers without subquery

In this post, we can discuss, how we can sum positive and negative numbers without subquery.

```ID   Number
--------------------------
1	-7
2	-8
3	-6
4	-5
5	-4
6	-3
7	3
8	4
9	5
10	6
11	8
12	7
```

The sum of a positive and negative integer is 33, and -33 respectively.

```select SUM(Number) as [Sum] from SumPositiveNegative
```

Getting the Sum value is 0

```select SUM(Number) as [Sum] from SumPositiveNegative where Number<=0

select SUM(Number) as [Sum] from SumPositiveNegative where Number>=0
```

These two queries return the -33 and 33 results respectively but we need the same result in the same query, not in two separate queries.

Here We can use the `<a href="https://www.w3schools.com/sql/sql_case.asp" target="_blank" rel="noreferrer noopener">case when</a>` statement to get the required result sets.

```select
sum(case when Number>=0 then Number end) [PSum]
,Sum(case when Number<=0 then Number end ) [NSum]
from SumPositiveNegative
```

The above query will return the expected result.