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 vote196 views2 answers
Search stored procedures
SQL
1 vote193 views1 answer
Pl sql insert into table
SQL
1 vote177 views1 answer
Show indices in mysql table
SQL
0 vote199 views1 answer
Sqlite update where exists
SQL
0 vote190 views1 answer
Access mysql database docker container shell
SQL
0 vote231 views1 answer
Get last inserted primary key
SQL
1 vote191 views1 answer
Add constraint sql
SQL
1 vote198 views1 answer
Sql where last 12 months
SQL
0 vote196 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
9 votes185 views2 answers
Oracle all tables in schema
SQL