
11.0K
JEComment “data” for my intro to SQL course, perfect for complete newbies to build your first project in 30 min.
Most common data interview question ⬇️ save this for later!
One of the most common interview questions is this: What’s the difference between ROW_NUMBER, RANK, and DENSE_RANK?
Most business problems only need ROW_NUMBER, but for some reason hiring managers are OBSESSED asking this one!!
• ROW_NUMBER: sequential ranking, no duplicates, no skipped numbers
• RANK: duplicates share the same rank, but numbers get skipped after ties
• DENSE_RANK: duplicates share the same rank, no skipped numbers
🏷️ data analytics, data analytics project, data project
@jessramosdata










