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

2 votes117 views1 answer
Select sid oracle
SQL
0 vote184 views2 answers
Transaction php
SQL
0 vote163 views1 answer
Mysql concat and use as where column
SQL
15 votes157 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote187 views2 answers
Insert data mysql with cmd
SQL
4 votes165 views1 answer
Sql delete where in select
SQL
7 votes171 views4 answers
How to reset the identity column in sql server
SQL
0 vote201 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote188 views2 answers
What is 1=2 in sql
SQL
4 votes162 views1 answer
Force drop all tables postgres
SQL