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 vote132 views1 answer
Apt install sql server
SQL
-1 vote91 views1 answer
Mysql how to set update or create
SQL
0 vote137 views1 answer
Delete ids between sql
SQL
0 vote149 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
1 vote145 views1 answer
Increase existing date in sql oracle
SQL
0 vote139 views1 answer
Get rows from 1 table with other table empty mysql
SQL
12 votes160 views1 answer
Create column sql server
SQL
0 vote130 views1 answer
How to find symmetric pairs in sql
SQL
2 votes141 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
1 vote207 views1 answer
Truncate table in postgresql and reset id
SQL