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 vote118 views1 answer
Syntax for changing column size in mysql
SQL
2 votes170 views1 answer
Sql compare strings
SQL
14 votes153 views6 answers
Finding duplicate rows mysql
SQL
10 votes92 views2 answers
Mysql select timestamp group by day
SQL
6 votes135 views2 answers
Mysql 1 day ago
SQL
1 vote123 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
2 votes140 views3 answers
Oracle show column of table
SQL
0 vote247 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote134 views1 answer
Mysql get first 2 characters of string
SQL
1 vote120 views1 answer
Sql avg group by
SQL