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

7 votes116 views3 answers
Foreign key oracle
SQL
0 vote105 views1 answer
Mysql jdbc timezone
SQL
3 votes104 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote123 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
23 votes113 views2 answers
Query to delete a database in mysql
SQL
0 vote124 views1 answer
Insert value in identity
SQL
1 vote113 views1 answer
Sample in sql
SQL
0 vote121 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
1 vote103 views1 answer
Adding a default constraint to an existing column in sql
SQL
-1 vote114 views3 answers
My sql alter table
SQL