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

15 votes307 views6 answers
Laravel db transaction
SQL
0 vote327 views1 answer
Select the date 30 days less that the todays date sql request
SQL
1 vote340 views1 answer
Import sql file from laravel
SQL
150 votes546 views10 answers
Grepper
SQL
0 vote280 views1 answer
Download mysql database to excel in android studio
SQL
23 votes268 views6 answers
Create table sql
SQL
0 vote288 views1 answer
Mysql add root password
SQL
0 vote248 views0 answer
SQL
0 vote286 views1 answer
Mysql preg replace
SQL
0 vote280 views1 answer
Mysql money value
SQL