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

0 vote298 views1 answer
Systemverilog unique constraint unique values
SQL
20 votes324 views3 answers
Update values in select statement sql
SQL
1 vote308 views2 answers
Sql example query
SQL
0 vote305 views1 answer
Contact mysql column field
SQL
1 vote300 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote323 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote303 views1 answer
Install postgresql 12 on debian 10
SQL
3 votes301 views2 answers
Mysql HAVING
SQL
1 vote351 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote345 views1 answer
Add super privilege mysql
SQL