#rowsvsrange — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #rowsvsrange, aggregated by home.social.
-
Window ROWS vs RANGE Frame Difference?!
ROWS and RANGE frames are COMPLETELY different! ROWS counts physical rows, RANGE groups by value. Same query, DIFFERENT results. This will confuse you!
#sql #sqltricks #windowfunctions #rowsvsrange #framespecification #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #advancedsql #database