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

5 votes254 views1 answer
Mysql where one year ago
SQL
27 votes293 views3 answers
Mysql delete row
SQL
0 vote223 views1 answer
Find largest table in mysql database
SQL
0 vote247 views2 answers
PostgreSQL having
SQL
2 votes264 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote249 views1 answer
Postgres populate table from another table
SQL
6 votes237 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote243 views1 answer
Get the Db column names from a SqlDataReader
SQL
1 vote244 views1 answer
Oracle sql first day of year
SQL
1 vote228 views2 answers
Sql now - 1 day
SQL