A Really Simple way to know the difference between ROW_NUMBER(), NTILE(n),RANK() and DENSE_RANK()?

Hey Guys,welcome back. I'm sure you've come across sql servers ranking functions and thought (what the fudge!!!) ....or maybe you didn't. Well either way here is a really easy example to tell the difference. Start by creating a sample table. We are going to be using Microsoft SQL Server for this. Decide on the database …