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 vote143 views1 answer
Less than and between in sql query
SQL
0 vote160 views2 answers
Mysql add days to date
SQL
0 vote131 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
2 votes140 views1 answer
Sqlite indexes
SQL
0 vote155 views1 answer
Mysql installer no packages found
SQL
0 vote106 views1 answer
Copy data from cell to cell mysql
SQL
0 vote132 views1 answer
Oracle index hint
SQL
0 vote133 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
7 votes143 views1 answer
Query postgres delete duplicates
SQL
9 votes145 views4 answers
Mysql set id auto increment
SQL