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 vote345 views1 answer
Login failed for user sql server
SQL
1 vote330 views1 answer
SQL Integer devision
SQL
8 votes341 views1 answer
Oracle search text in all packages
SQL
-1 vote332 views3 answers
How to restart mysql in linux
SQL
0 vote357 views1 answer
Sql ssrs
SQL
0 vote333 views1 answer
Raiserror with nowait
SQL
12 votes351 views6 answers
How to install sqlite3 in python
SQL
0 vote313 views1 answer
How to change the field size of an existing column
SQL
0 vote327 views2 answers
Select columns from 2 tables with foreign key
SQL
1 vote316 views1 answer
Ef core 5.0 usesqlserver not found
SQL