Find duplicates with RANK

Let's clean out duplicates! Here's how.

1️⃣ Check if duplicates exists.
Use 𝙶𝚁𝙾𝚄𝙿 𝙱𝚈 + 𝙲𝙾𝚄𝙽𝚃(*) to find duplicates. See example 1 in image below.

2️⃣ Identify exact rows that are duplicated.
Use 𝚁𝙰𝙽𝙺 𝙾𝚅𝙴𝚁(𝙿𝙰𝚁𝚃𝙸𝚃𝙸𝙾𝙽 𝙱𝚈 𝚌𝚘𝚕𝚜). See example 2.

What does 𝚁𝙰𝙽𝙺 𝙾𝚅𝙴𝚁(𝙿𝙰𝚁𝚃𝙸𝚃𝙸𝙾𝙽 𝙱𝚈 𝚌𝚘𝚕𝚜) do?
👉 divides the table into multiple partitions, one for each unique value of cols, then
👉 assigns a rank from 1 to the number of rows in the partition, then
👉 returns more than 1 if the row is duplicated

You can even find duplicated values in TWO columns.

In example 3, I find duplicated show_name and actor_name with this:
𝚁𝙰𝙽𝙺 𝙾𝚅𝙴𝚁(𝙿𝙰𝚁𝚃𝙸𝚃𝙸𝙾𝙽 𝙱𝚈 𝚜𝚑𝚘𝚠_𝚗𝚊𝚖𝚎, 𝚊𝚌𝚝𝚘𝚛_𝚗𝚊𝚖𝚎) > 𝟷

As usual, full example below.