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 vote171 views1 answer
Key validation sql
SQL
0 vote148 views1 answer
Mysql command prompt date insert format
SQL
1 vote147 views1 answer
Mariadb case switch
SQL
7 votes151 views1 answer
Mysql remote connection command line
SQL
9 votes155 views4 answers
Mysql set id auto increment
SQL
0 vote162 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote135 views1 answer
Update using case in mysql
SQL
1 vote153 views1 answer
How to select rows with no matching entry in another table?
SQL
28 votes145 views4 answers
Show tables mysql
SQL
0 vote148 views1 answer
Postgres declare variable
SQL