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 vote211 views1 answer
Sql requete number pair
SQL
9 votes188 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote255 views1 answer
Delete from IN subquery
SQL
0 vote183 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote198 views1 answer
Sql cmd no truncate
SQL
2 votes181 views1 answer
Oracle virtual column
SQL
-1 vote188 views1 answer
How to dump .csv file into mysql
SQL
2 votes258 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote272 views2 answers
Search stored procedures by name
SQL
1 vote241 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL