See if a combination of 3 columns is unique

Hi all,

I need to check if the combination of 3 columns, First name , last name and birth date is unique in the data set.

So I thought to use group by. But that doesn't solve the issue of checking if the combination is unique.

Any idea's?

 

Thanks!

You can group by the three columns and then compute the count. If the count is > 1 then it's not unique.