#rankingfunctions — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #rankingfunctions, aggregated by home.social.
-
RANK vs DENSE_RANK vs ROW_NUMBER?!
Three ranking functions, THREE different behaviors! RANK skips numbers, DENSE_RANK doesn't, ROW_NUMBER always increments. This difference BREAKS logic!
#sql #sqltricks #rank #denserank #rownumber #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #rankingfunctions #advancedsql