Special welcome gift. Get 50% off your first courses with code “AS50”. Find out more!

HomeInterviewExplain the difference between RANK and DENSE_RANK functions in Oracle SQL.
courses 15

Explain the difference between RANK and DENSE_RANK functions in Oracle SQL.

RANK and DENSE_RANK both assign rankings to result rows. 

With RANK, when two or more rows have the same values, they’ll be assigned the same rank, and the subsequent rank will be skipped. 

Meanwhile, DENSE_RANK provides a consecutive ranking and doesn’t leave gaps in ranking even when duplicate values exist.  

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

Categories

ads sidebar 1

You May Also Like

Oracle has several modes for shutting down the database: In normal mode, the database is shut down by default. It...
Materialized views are items that contain condensed sets of data from base tables that have been summarized, clustered, or aggregated. They...
Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also...