Nikhil Bangad

Data engineering leader known for spearheading impactful solutions and managing high-performing teams. With a decade under my belt, I specialize in complex data model design and scalable practices. Passionate about sharing my expertise and giving back to the community
  • Interests: Data Engineering
  • Skills: SQL, Python, Data Modeling, Data Visualization, Data Leadership, Influence, Communication

All authors

SQLServerCentral Article

SQL Window Functions Series: RANK() and DENSE_RANK()

Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

You rated this post out of 5. Change rating

2023-11-20 (first published: )

1,290 reads

All authors

Blogs

SQL Server Quickie #46 – SQL Server on Linux

By

Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...

Giving a Security Webinar this Wednesday

By

If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...

Write to backup block blob device failed. Device has reached its limit of allowed blocks.

By

Picture this, you’re happily backing up your database to a Azure blob storage until...

Read the latest Blogs

Forums

Dropping a Service from Service Broker crashes server

By dwebb@soundphysicians.com

I'm having an issue trying to drop a service.  When I issue the drop...

SQL MI - SQL Jobs failing with User Manager\ContainerAdministrator.

By DanielP

This is strange, any SQL job that sends out Emails via 'msdb.dbo.sp_send_dbmail ' are...

Tempdb: is it being used?

By dopydb

hi so i have a really old application that is used to process data...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Skipping Checks when Detaching

See possible answers