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 vote163 views1 answer
Sql developer sql worksheet not showing
SQL
18 votes134 views4 answers
Foreign key mySql
SQL
0 vote170 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote130 views1 answer
Error code 1241 mysql
SQL
1 vote139 views1 answer
Access the postgres psql
SQL
0 vote157 views2 answers
Php convert dbf to mysql
SQL
1 vote167 views1 answer
Oracle repeat_interval 5 minutes
SQL
12 votes153 views5 answers
Sql primary key
SQL
1 vote153 views1 answer
Get parameter value in mysql trigger
SQL
1 vote129 views1 answer
Oracle aleter trigger ora-01031
SQL