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 vote242 views1 answer
Split a string with expression and get the last value of split sql
SQL
9 votes259 views2 answers
Oracle all tables in schema
SQL
0 vote281 views1 answer
Print mysql
SQL
4 votes281 views2 answers
Installing sql on ubuntu
SQL
0 vote276 views1 answer
Linebreak sql
SQL
1 vote292 views1 answer
Avg mysql
SQL
8 votes288 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote265 views1 answer
Mysql not supported auth mode
SQL
0 vote261 views1 answer
Postgre admin slow
SQL
2 votes266 views1 answer
Oracle index size calculation
SQL