I have the following table :
i've tried a pivot function that looked like this :
but it didn't worked, since there no agregation i think..
my goal is to make the table looked like this
do me a favour, thanks!
Asked
Active
Viewed 21 times
0
-
Number of columns must be finite and known in advance in PIVOT. let us know how many columns is needed in the result – Popeye Dec 01 '20 at 12:30
-
1Does [this](https://stackoverflow.com/questions/15491661/dynamic-pivot-in-oracle-sql) answer your question? – gsalem Dec 01 '20 at 14:53
-
especially you can look at the dynamic solutions within the shared link. – Barbaros Özhan Dec 01 '20 at 20:54