Using SQL Runner to pull data - How to Pivot within Query

[chad_fender-165]

I’m writing a pretty basic query in SQL Runner that goes something like this:

Select id, amount from transactions where id = ‘Value’.  This then may return > 1 row based on the transactions. What I’m looking to do is have everything returned into one row with the first column being the ID and then any subsequent “values”in their own Value column.