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 vote112 views1 answer
Mysql page segment
SQL
8 votes119 views2 answers
Alert table name mysql
SQL
1 vote111 views1 answer
Avg mysql
SQL
2 votes123 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote114 views1 answer
Insufficient memory to excute the sql query
SQL
-2 votes127 views1 answer
Mysql not empty
SQL
2 votes116 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote119 views1 answer
Oracle archivemode
SQL
2 votes113 views1 answer
Oracle drop sequence if exists
SQL
0 vote128 views1 answer
Snowflake drop column
SQL