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

1 vote117 views1 answer
Import in mysql without a software
SQL
0 vote158 views1 answer
Mysql trim characters
SQL
0 vote184 views1 answer
Sort by
SQL
1 vote165 views1 answer
How to use db.execute
SQL
0 vote156 views1 answer
Postgresql heritage
SQL
2 votes145 views1 answer
Oracle run_duration average
SQL
11 votes161 views1 answer
Creating tables in sql with python
SQL
8 votes143 views1 answer
Oracle add month
SQL
2 votes162 views1 answer
Mysql application.properties spring boot
SQL
0 vote185 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL