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 vote362 views1 answer
Postgresql find biggest table
SQL
12 votes344 views2 answers
Find duplicates mysql column
SQL
0 vote330 views1 answer
Postgress append string in select
SQL
0 vote329 views1 answer
Mariadb number format
SQL
0 vote334 views2 answers
Create sequence if not exists postgres
SQL
0 vote360 views1 answer
View psql output in horizontal scrolling
SQL
1 vote352 views1 answer
Postgresql escape single quote
SQL
0 vote350 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
17 votes330 views6 answers
Sql select distinct
SQL
0 vote342 views1 answer
Why we have to set the password for my sql server
SQL