Обсуждение: Pivot table without crosstab

Hello,

I have a little problem with SQL statement to get values from a table.
Given a table:

Name  Val1 Val2 Val2
Smith     0      1     0
Smith     1      0     0
Smith     0      0     1
Roberts  1      0     0
Roberts  0      0     1

I need to get:
Name  Val1 Val2 Val2
Smith    1      1     1
Roberts 1      0     1


Best regards

Hi again,

I got it already. all you need to do is to use SUM and CASE.

2015-02-09 14:59 GMT+01:00 Lukasz Brodziak <lukasz.brodziak@gmail.com>:
> Hello,
>
> I have a little problem with SQL statement to get values from a table.
> Given a table:
>
> Name  Val1 Val2 Val2
> Smith     0      1     0
> Smith     1      0     0
> Smith     0      0     1
> Roberts  1      0     0
> Roberts  0      0     1
>
> I need to get:
> Name  Val1 Val2 Val2
> Smith    1      1     1
> Roberts 1      0     1
>
>
> Best regards