Difference between RANK() and DENSE_RANK()

Опубликовано: 15 Апрель 2020
на канале: Ashish Thakur

1,765

For ETL Testing Tutorial free videos Refer : https://www.etltestingtutorial.com/et...

For ETL Testing Training Course Details refer : https://www.etltestingtutorial.com/et...

Both RANK() and DENSE_RANK() provide ordered partition. The one and only difference between RANK() and DENSE_RANK() function is the fact that RANK() will assign non-consecutive ranks to the values in a set in the case of tie, which means that with RANK() there will be gaps between the integer values when they are common where as in DENSE_RANK no ranks are skipped if there are ranks with multiple items.

Subscribe to Our Channel to get video updates. Hit the subscribe button above: https://bit.ly/30YnBoI

Facebook:   / whizdomtraining
LinkedIn:   / whizdom-training-s
Instagram:   / whizdomtrainings

#bothrank #denserank #etltrainings