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 vote266 views1 answer
Postgresql create table default value timestamp
SQL
0 vote217 views1 answer
Select new table sql
SQL
0 vote227 views2 answers
Oracle ora-00054 how to unlock
SQL
1 vote185 views2 answers
Mysql spring boot application.properties
SQL
0 vote200 views3 answers
Database restoring error
SQL
4 votes188 views2 answers
Postgres update single column
SQL
16 votes201 views3 answers
Jwt secret key generator laravel
SQL
0 vote201 views1 answer
Implicit inner join table alias with id values
SQL
0 vote204 views1 answer
Sql server Cost Fifo query
SQL
1 vote227 views1 answer
Mysql select and count left join
SQL