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

1 vote178 views1 answer
Where date = max(date) in sql
SQL
0 vote173 views1 answer
Sql column as header
SQL
-1 vote177 views1 answer
Ssms connect with connection string
SQL
0 vote192 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote199 views1 answer
Oracle last connexion
SQL
7 votes217 views4 answers
Database dump mysql command
SQL
5 votes197 views1 answer
Oracle list days between two dates
SQL
0 vote165 views1 answer
Inser into example
SQL
3 votes173 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
1 vote197 views1 answer
Sql set auto increment back to 0
SQL