3 ms·
There are real use cases for pivoting data in SQL not only for presentation. Tables can be too "long". You need data points to be on the same row if you want t
by fifilura 3y ago
There are real use cases for pivoting data in SQL not only for presentation. Tables can be too "long".
You need data points to be on the same row if you want to do arithmetic operations on on different types of values. For example
k + 3.14* number_of_chimneys - 0.13 * age - 1.34*neigbourhood_criminality as house_price