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

3 votes202 views1 answer
Mysql load sql from file
SQL
3 votes213 views1 answer
Postgresql if null then 0
SQL
0 vote219 views1 answer
Mysql last friday of current month
SQL
1 vote214 views1 answer
Epoch time converter in snowflake
SQL
3 votes205 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote208 views1 answer
Frename oracle
SQL
0 vote216 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote213 views1 answer
Select multiple row from primary key sql
SQL
0 vote212 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote219 views1 answer
Compare field sql server
SQL