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

21 votes150 views4 answers
Oracle add column
SQL
1 vote136 views1 answer
Postgres check for foreign key
SQL
0 vote148 views1 answer
How to update sql server version
SQL
2 votes143 views3 answers
Current month mysql query
SQL
0 vote166 views1 answer
Mysql installer no packages found
SQL
20 votes181 views4 answers
How to find average in sql
SQL
0 vote135 views1 answer
Resulting Query
SQL
0 vote148 views1 answer
Date on SQL
SQL
2 votes152 views2 answers
Mysql alter column default
SQL
0 vote161 views1 answer
Load data infile mariadb slow
SQL