[sqlite] Transpose selected rows into columns

[Igor Tandetnik]

On 3/27/2015 11:48 AM, Drago, William @ CSG - NARDA-MITEQ wrote:
> I want the rows containing V0 and V5 to become columns like this:
>
> SerialNumber |  V0   |  V5
> -------------|-------|-------
> 123          | 0.136 | 0.599
> 124          | 0.126 | 0.587
> 125          | 0.119 | 0.602

select SerialNumber,
   max(case Stim when 'V0' then Resp else null end) V0,
   max(case Stim when 'V5' then Resp else null end) V5
from MyTable group by SerialNumber;

-- 
Igor Tandetnik