Problem: I have to make each row as column using SQL statement.
Source Table
Colour_id Colour_desc Value1_min Value1_max Value2_min Value2_max
1 Green 0 0.499 0 0.299
2 Amber 0.5 0.8 0.03 0.05
I want a output looks like below:
Value1_min_Green Value1_max_Green Value2_min_Green Value2_max_Green Value1_min_Amber Value1_max_Green Value2_min_Amber Value2_max_Green
0 0.499 0 0.299 0.5 0.8 0.03 0.05
Any Approach or suggestion to get above result as output?