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

0 vote173 views1 answer
Two inner joins sql
SQL
1 vote161 views1 answer
How to see all table partition in oracle
SQL
1 vote172 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote173 views1 answer
Restore backup mysql .gz
SQL
0 vote174 views1 answer
Template MySQL Zabbix agent
SQL
0 vote169 views1 answer
Docker export psql sql
SQL
59 votes286 views6 answers
Alter table sql
SQL
2 votes153 views1 answer
Merge two columns in sql oracle
SQL
10 votes183 views2 answers
What is database
SQL
1 vote169 views3 answers
Sql server get week dates from week number
SQL