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

7 votes279 views1 answer
Sql pagination oracle
SQL
0 vote260 views1 answer
What is default mysql database password in linux
SQL
0 vote266 views1 answer
Sql server port 1434
SQL
0 vote255 views1 answer
Sql drop default
SQL
0 vote288 views1 answer
Postgresql inheritance
SQL
1 vote279 views1 answer
Retrieve meaning
SQL
9 votes284 views5 answers
Sql delete duplicate rows but keep one
SQL
61 votes429 views6 answers
Mysql add column
SQL
0 vote262 views5 answers
Sql table intermédiaire
SQL
1 vote268 views1 answer
Drop df constraint sql server
SQL