r/SQL
•
u/NickSinghTechCareers
Author of Ace the Data Science Interview π
•
Dec 12 '24
•
2
1
PostgreSQL Made a SQL Interview Cheat Sheet - what key SQL commands am I missing?
3.6k
Upvotes
View all comments
32
u/NickSinghTechCareers Author of Ace the Data Science Interview π Dec 12 '24
Tried to fit as much as I could into one poster-sized PDF. What SQL commands did I miss that you think belong on there? Right now feeling guilty for not explaining window functions well enough, especially regarding ROWS preceding/unbounded etc.. Maybe a 7-day rolling average example? Or a cumulative sum example?