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 vote235 views1 answer
Ms sql print more than 1 variable
SQL
1 vote298 views1 answer
Sql group by sum with condition
SQL
0 vote242 views1 answer
Expose db in virtualbox
SQL
0 vote294 views1 answer
OFFSET consulta mysql
SQL
10 votes278 views2 answers
Sql rtrim
SQL
3 votes288 views2 answers
Df to sql pandas sql achemy
SQL
2 votes253 views1 answer
Foreign key example in dbms
SQL
0 vote279 views1 answer
Join in update query in mysql
SQL
1 vote287 views1 answer
List all triggers in SQL Server
SQL
0 vote271 views1 answer
Postgresql remove duplicate rows 2 columns
SQL