June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Pluralsight Giving Away Free Subscription to Quiz Participants

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks, SQLAuthority News
Joes 2 Pros
I am sure readers of this site are familiar with Pluralsight.  It is an online training site that describes itself as “a company created by developers, specifically for developers.”  At their site you can find training courses on a variety of topics and weekly webcasts by industry specialists. Right now…
Read More

SQL SERVER – Ranking Functions – RANK( ), DENSE_RANK( ), and ROW_NUMBER( ) – Day 12 of 35

Pinal Dave
SQL Tips and Tricks
Joes 2 Pros, Ranking Functions, SQL Scripts, SQL Server

In this blog post we will discuss about Ranking Functions like RANK( ), DENSE_RANK( ), and ROW_NUMBER( ).

Ranking Functions (Part 1)

There are four ranking functions in SQL server. Today we will look at RANK( ), DENSE_RANK( ), and ROW_NUMBER( ).These functions all have the same basic behavior. Where they differ is in the handling of tie values. These three functions produce identical results, until a tying value in your data is present.

Read More