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

31 votes173 views3 answers
Sql count(*)
SQL
0 vote169 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote178 views1 answer
Normalization in database
SQL
3 votes173 views1 answer
Two select sql
SQL
0 vote183 views1 answer
Sql update subtract value
SQL
1 vote352 views2 answers
Sql unique rows
SQL
0 vote204 views1 answer
Implode in sql query
SQL
21 votes225 views3 answers
Average sql
SQL
6 votes167 views1 answer
Phpmyadmin password root
SQL
12 votes193 views5 answers
Rename table in mysql
SQL