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 vote201 views2 answers
Drop table with constraints
SQL
0 vote177 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote183 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote180 views1 answer
If column value is null then in mysql
SQL
0 vote181 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote215 views1 answer
Mysql record group by created date count
SQL
2 votes258 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote179 views2 answers
How to generate a unique random number in mysql
SQL
2 votes186 views3 answers
Current month mysql query
SQL
0 vote176 views1 answer
Sql menampilkan data tabel
SQL