How to fetch a sample of data within each group - Teradata
Scenario: We need to select a random sample of 5 in each status type
TABLE1
| MEMBER | STATUS |
| 89 | A |
| 34 | A |
| 25 | R |
| 27 | S |
| 69 | J |
| 32 | R |
| 39 | J |
| 55 | S |
| 32 | A |
Solution:
SEL Member, status
FROM TABLE1
QUALIFY ROW_NUMBER() OVER (
PARTITION BY status
ORDER BY NULL) <= 50;nVector
posted on 20 Aug 18Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
Post Comment