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

22 votes116 views3 answers
Year format in date mysql
SQL
1 vote100 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
7 votes116 views2 answers
Sql remove duplicates based on column
SQL
2 votes113 views1 answer
Mariadb select multiple rows into one column
SQL
3 votes121 views2 answers
Mysql import gz
SQL
0 vote123 views1 answer
Sql server insert inner join
SQL
4 votes191 views4 answers
Update select mysql
SQL
0 vote100 views1 answer
Sqlite update only if greater
SQL
0 vote113 views2 answers
MySQL PARTITION BY month automatically
SQL
17 votes122 views5 answers
Order by sql
SQL