//
sign in
Post
by @danabra.mov
PostEmbed
by @danabra.mov
Record
by @jimpick.com
Record
by @atsui.org
+ new component
Post
You can number rows in #SQL with ROW_NUMBER => unique, consecutive numbers DENSE_RANK => ties have same rank, consecutive ranks RANK => ties have same rank, rank after ties = row number => gaps Jess Ramos shows these in action and lists common use cases buff.ly/pHiiY53
7d
⚡Free 5-Day Data Career Kickstart https://www.bigdataenergycourses.com/kickstart If you're preparing for a data interview, you need to know the difference between ROW_NUMBER, RANK, and DENSE_RANK —…
buff.ly
Master SQL Window Functions: ROW_NUMBER, RANK, and DENSE_RANK
SQLDaily