I am new to SQL, can you please help me in retrieving the values as per below screen shot and below is my backend query results.(backend-data.png), i want to display the data in sql-output.png format. I am trying to sort the DEG column (all the 0's , 8, 160) and get the corresponding values. For an instance, if DEG is 0, I should get the corresponding values(for height 5) ' i.e. (0.91,-0.29, -1.78,-2.05 etc). Similarly i have to group and display the values as per the screenshot L02Kj.png. : /storage/temp/4188-sql-output.png
First, I try to create a temporary table which contains the values from COL_1 for DEG = 0. I move the values with pivot, in rows in pivot_table. Again, a temporary table which contains the values from COL_2 for DEG = 0. I move the values with pivot in rows, insert in above table (pivot_table).