I have a table like this:
id stage(varchar)
1 ["a","b"]
2 ["c"]
and I need to retrieve the data as the following format:
id stage
1 a
1 b
2 c
How should I write my SQL in AWS Redshift?
You need to sign in to view this answers
Leave feedback about this