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 vote182 views1 answer
Create duplicate table in postgresql
SQL
1 vote202 views1 answer
Sql group by error
SQL
1 vote175 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote214 views1 answer
How to get initials in sql
SQL
0 vote219 views1 answer
Sql server port 1434
SQL
0 vote223 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote230 views1 answer
Plpgsql raise notice
SQL
0 vote229 views2 answers
PostgreSQL having
SQL
1 vote220 views1 answer
Psql datetime grather than
SQL
14 votes212 views2 answers
How to auto increment in sql
SQL