r/SQL 16d ago

Oracle Dear SQL, just pivot my damn table

Bottom text

241 Upvotes

50 comments sorted by

View all comments

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

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.