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

  • 27 July 2022
  • 0 replies

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.

This topic has been closed for comments