Skip to content
Advertisement

How to sample from different values in a column but only return records that are unique from another column?

I am struggling with a sampling issue using Teradata

Below is the format of the data

I would ideally like to return a sample number for each entry in Group but with only unique values from ID.

Below is the current query I produced but this returns duplicates for ID

Advertisement

Answer

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement