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 vote213 views2 answers
Sql convert datetime to year month
SQL
0 vote228 views1 answer
Date on SQL
SQL
52 votes364 views6 answers
Rename column sql
SQL
0 vote233 views1 answer
How to set sql_mode for a query in CI model
SQL
6 votes252 views2 answers
Foreign key sqlite3 python
SQL
0 vote219 views1 answer
Sql select inside select sub query
SQL
1 vote227 views2 answers
Find nth highest salary of an employee
SQL
-1 vote246 views1 answer
Phinehas Psalm 106
SQL
1 vote229 views1 answer
Base64 encode sql server
SQL
0 vote260 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL