Sql random sampling per group

with randomly_sorted_users as (

    select
        user_id,
        signup_date,
        row_number() over(partition by date_trunc('year', signup_date)
                            order by random()) as random_sort
    from
        user_table

)
select
    user_id,
    signup_date
from
    randomly_sorted_users
where
    random_sort <= 5

Source: stackoverflow.com

Similar codes

1 vote308 views1 answer
How to set up a trigger in sql
SQL
0 vote300 views1 answer
Drop tables from local database postgres pgadmin
SQL
1 vote304 views1 answer
What is in condition in sql
SQL
1 vote279 views2 answers
Oracle 18c xe ORA-65096
SQL
2 votes300 views1 answer
How to find table table in stored procedure sql server
SQL
1 vote259 views2 answers
Mysql update table from another table
SQL
-2 votes293 views2 answers
Union all in sql
SQL
0 vote266 views1 answer
Date diff sql
SQL
0 vote361 views1 answer
Run docker container with database as rds metabase
SQL
13 votes464 views4 answers
Sql joining 3 tables
SQL