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 vote207 views3 answers
Group_concat sql server
SQL
-1 vote149 views1 answer
How to create script to connect to oracle database and run query
SQL
3 votes240 views3 answers
Mysql auto increment after delete
SQL
0 vote204 views1 answer
Django mysqlclient connection string
SQL
1 vote142 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote190 views1 answer
Minecraft duping allowed servers
SQL
9 votes203 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote205 views1 answer
Database schema for mcqs type exam in sql
SQL
3 votes275 views1 answer
Oracle function
SQL
0 vote207 views2 answers
Pop sql insert value into
SQL