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 vote347 views1 answer
Odd record sql query
SQL
0 vote350 views1 answer
Python mysqlclient library not found for -lssl
SQL
7 votes329 views1 answer
Grant schema permissions postgres
SQL
1 vote406 views1 answer
How to check all scheduled jobs in oracle
SQL
-1 vote342 views1 answer
Ssms connect with connection string
SQL
0 vote337 views1 answer
Rabbitmq service not starting
SQL
0 vote400 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote383 views2 answers
Get item by composite primary key mysql
SQL
4 votes445 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote355 views1 answer
WHERE not regex in SQL
SQL