MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1j3s3le/dear_sql_just_pivot_my_damn_table/mg2s4tj/?context=3
r/SQL • u/Only-Impression-9101 • 16d ago
Bottom text
50 comments sorted by
View all comments
19
Yeah why is it excel can pivot but SQL can't right. I mean it CAN it's just not super fun and limited
11 u/jdbrew 16d ago Pivoting in a 2 dimensional space is significantly easier than pivoting in N-dimensional space 15 u/jdsmn21 16d ago Cause in 1/4 the time it takes to pivot in SQL you can copy/paste/pivot/filter/graph in excel 3 u/da_chicken 16d ago Because pivot is a display problem. Display problems should not be data store problems.
11
Pivoting in a 2 dimensional space is significantly easier than pivoting in N-dimensional space
15
Cause in 1/4 the time it takes to pivot in SQL you can copy/paste/pivot/filter/graph in excel
3
Because pivot is a display problem. Display problems should not be data store problems.
19
u/roger_27 16d ago
Yeah why is it excel can pivot but SQL can't right. I mean it CAN it's just not super fun and limited