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 vote329 views1 answer
Call rest api from postgresql
SQL
0 vote348 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
1 vote344 views1 answer
Mysql check if string contains comma separated
SQL
3 votes341 views1 answer
Oracle drop user
SQL
1 vote357 views2 answers
Postgres cast as decimal
SQL
0 vote340 views1 answer
Sql period overlap
SQL
1 vote357 views1 answer
Sql set auto increment back to 0
SQL
0 vote356 views1 answer
Create table like sql
SQL
4 votes285 views3 answers
Create table if not exists postgresql
SQL
0 vote342 views1 answer
Sql alchemy escape ; in insert statement
SQL