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 vote35 views3 answers
Remove unique key from a table
SQL
6 votes32 views1 answer
Phpmyadmin password root
SQL
1 vote48 views1 answer
T-SQL / AZURE Reseed
SQL
2 votes41 views1 answer
Brew start postgres manual
SQL
1 vote41 views2 answers
List tables sqlalchemy
SQL
8 votes55 views10 answers
Sql
SQL
8 votes44 views1 answer
Mac restore mysql database command line
SQL
4 votes37 views2 answers
Tsql utf to local time
SQL
0 vote33 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
6 votes30 views4 answers
Eloquent to sql with bindings
SQL