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 vote265 views2 answers
Insert into
SQL
0 vote279 views1 answer
Sql script get all stored procedures from database
SQL
15 votes256 views4 answers
Pl sql
SQL
0 vote278 views1 answer
To Create directory
SQL
0 vote257 views1 answer
Sql select all tables from database change url
SQL
1 vote267 views1 answer
Postgresql datetrunc too slow
SQL
0 vote261 views1 answer
Casterar postgres
SQL
0 vote278 views1 answer
Add sqlcmd to path linux
SQL
7 votes265 views1 answer
Connect mysql docker
SQL
1 vote266 views1 answer
Psql connections
SQL